Matrix Visual - Empty row flattened but clickable

[VIRJOVAN]

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 !

[VIRJOVAN · Accepted solution]

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]

@VIRJOVAN 

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.

[DanieleUgoCopp]

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.