cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
mmerchak Regular Visitor
Regular Visitor

Some matrix values are showing as blanks unless filtered

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.

 

PBI Error Matrix1.JPGThe values are not appearing in the cells, but there are totalsPBI Error Matrix2.JPGOnce the visual is filtered, the values now appear in the cells.

Note this is not the entire matrix, just a sample. The whole matrix has 12 sections of about this size.

 

4 REPLIES 4
Community Support Team
Community Support Team

Re: Some matrix values are showing as blanks unless filtered

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

 

 

Community Support Team _ Lin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
mmerchak Regular Visitor
Regular Visitor

Re: Some matrix values are showing as blanks unless filtered

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!

manoymon Regular Visitor
Regular Visitor

Re: Some matrix values are showing as blanks unless filtered

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"?

Highlighted
mmerchak Regular Visitor
Regular Visitor

Re: Some matrix values are showing as blanks unless filtered

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.