Show column names in Matrix

[SR1]

Hi,

Is it possible to show the column names in a matrix visualization even when there are no values for that column ? I want to show column name with empty rows.

[v-piga-msft · Accepted solution]

Hi @SR1,

What about creating a calculalted column with IF and ISBLANK function like below.

Column = IF(ISBLANK('Table Name[Column Name]),"Column Name")

Then use this calculated column in matrix columns field.

If you still need help, please share some data sample and your desired output sothat we could help further on it.

Best Regards,

Cherry

[davehus]

Hi - Have you tried right clicking on the dimension you want to see everything for and select Show Items With No Data

[SR1]

@davehus Thanks for replying. Yes that option is checked. But I don't see the column names with no data.