Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
This is the first time I have run into this error. In the matrix visual some of the values are showing as blank, even when they are not. The totals show up just fine. This matrix has two row values, shown in a hierarchical drill down so that both row values are visible. Once I filter down to one of the first row values, the data appears in the cells. What is going on? Is the data set to big? The main dataset in question is around 500K rows.
Note this is not the entire matrix, just a sample. The whole matrix has 12 sections of about this size.
After digging in further, I have noticed that when I uncheck the "Show items with no data" option then everything shows up correctly. So I guess it might just be some bug of some sort. I'll see if it goes away after downloading this month's update. If not I will try to upload a sample.
Also when I go from a graph to a matrix the issue does not happen.
It's so strange!
If I am not mistaken, I am having the exact same problem.
https://community.powerbi.com/t5/Desktop/Matrix-Missing-Values/m-p/552513#M260056
I was also able to fix it with the same solution you mentioned, but I didn't want to go that route.
Were you able to find another solution without unchecking the "Show items with no data"?
This is the same issue!! It is so strange.
I haven't been able to find a fix to it. (I thought I had found something before but it is not working now).
Unfortunately I haven't been able to find the time to create a version to upload so people can look at it.
hi, @mmerchak
I have tested on my side, but not reproduce the issue.
If possible, please share sample pbix file for us, You can upload it to OneDrive or Dropbox and post the link here. Do mask sensitive data before uploading.
Best Regards,
Lin
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
135 | |
118 | |
101 | |
71 | |
61 |