Forum Discussion
Solved
Matrix Visual - Empty row flattened but clickable
Hello All I have a matrix visual with an empty row which is flattened. It is clickable and it filters the matrix on the side Show elements without data is enabled and every matrix d...
Thanks for the answers !
I found an easier fix, it was the format of the measure.
On the left it was (# ###;-# ###;) (positive;negative;0) and on the right only (# ###)
by changing the format the row is appearing, with empty or 0 values as I wanted
it seems if you plan a format for a 0, the row is not flattened (or if you plan nothing for a 0 it flatten the row, if there are no relations or else)
Jaywant-Thorat
Super User
Super UserFix it in Power Query or Dimension modeling.
Don’t fight the Matrix formatting engine.
If you want, tell me:
Which table is on Rows
Which table provides the values
Relationship type (1:* or other)
I’ll suggest the exact modeling fix for your case.