Forum Discussion
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 disposition shows the same results.
How to show this flattened row as full as the others ?
Thank you !
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)
3 Replies
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)
Hello,
The row is flattened because there’s no real data behind that level of the hierarchy,
Power BI keeps the category visible and clickable, but since there are no child rows in the fact table, it has nothing to expand.
“Show items with no data” only prevents categories from disappearing, it doesn’t create empty child rows
I think there isn't a setting to force that row to look like the others, the only way around it is to give Power BI some data to work with, for example by using a dummy zero measure, replacing blanks with zero, or making sure the hierarchy comes from a proper dimension table. The cleanest fix is having a dimension or bridge table that already contains all the combinations you want to show.Fix 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.
