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
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.
Great to hear you figured it out, Marti!