Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Matrix Bug

There is a bug in matrix visuals identified in this forum post - it contains a link to a pbix.

 

Circumstances:

1. 2 fields on rows, drilled down

2. 1 field on columns.

3. There is only one column with values. (I don't know whether this matters).

4. Show items with no data on both rows and columns.

 

Results:

On the left is a correct result is in DAX Studio. However, note that each month that contains a blank value (or maybe only if it begins with a blank value?) loses all of its values in the Matrix.

Matrix Bug.PNG                    Matrix Bug 2.PNG

 

Thanks,

Nathan

Status: Accepted
Comments
v-qiuyu-msft
Community Support

Hi @Anonymous, 

 

The same issue has been reported internally before: CRI 113407872. I will consult it internally to see if there is any update. 

 

To work around the issue, you can turn off "Show items with no data" for matrix row groups, then the missing data will display. 

 

q6.PNG

 

Best Regards,
Qiuyun Yu 

v-qiuyu-msft
Community Support
Status changed to: Accepted
 
v-qiuyu-msft
Community Support

Hi @Anonymous, 

 

I got information that "The fix will be out by June 25, latest. The customer just needs to update to the latest version of desktop when it comes out in June, the PowerBI.com service will get the same fix a bit sooner." 

 

Best Regards,
Qiuyun Yu 

abdulbasit_ssi
Frequent Visitor

Matrix visual is showing blank randomly. any solution for this glitch?