Forum Discussion
Matrix Visual - Empty row flattened but clickable
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)
Super UserHello,
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.