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

3 Replies

  • v-piga-msft's avatar
    v-piga-msft
    Resident Rockstar
    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.