Forum Discussion

SR1's avatar
SR1
Helper I
7 years ago
Solved

Show column names in Matrix

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.
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • v-piga-msft's avatar
    v-piga-msft
    7 years ago

    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's avatar
davehus
Memorable Member
7 years ago

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

 

  • SR1's avatar
    SR1
    Helper I
    7 years ago

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