Forum

Blank Rows in the M...
 
Notifications
Clear all

Blank Rows in the Middle of my Table

3 Posts
2 Users
0 Reactions
73 Views
(@mrhyne)
Posts: 2
New Member
Topic starter
 

Hi, I'm new, so this is probably something simple to fix.

I have a basic table of employee data.  I want to build visuals of the employee population. I made 2 dimensions, Age and Tenure, where I created brackets, ex Age < 25, 25 - 30, 30 to 35, etc. I noticed on the Tenure graph that we have no one in the category of < 1 year, but in actuality we have plenty of recent hires. I looked at the data in excel and it looks fine. I looked at the table in Power BI and it has a number of blank rows together and then more data rows.

I googled "Power BI Blank Rows" and found mention of refreshing the table causing the problem. I did refresh the table today. I haven't worked on this project in a couple of months, so the number of employees we have today is less than what we had when I started. 

Any suggestions on how to fix this?

Thanks!

Marti Rhyne 

 
Posted : 24/08/2022 8:27 pm
(@mrhyne)
Posts: 2
New Member
Topic starter
 

So of course as soon as I signed out of the Forum I solved my problem. I went to Transform and Deleted all blank rows. Next, I rebuilt the chart and saw that on my Filters, the first label was not selected. Once I selected all the chart was correct.

 
Posted : 24/08/2022 8:39 pm
(@mynda)
Posts: 4761
Member Admin
 

Great to hear you figured it out, Marti!

 
Posted : 25/08/2022 5:48 am
Share: