Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

How to hide null columns in matrix table

Hi all, I search this topic in web but i couldn't get enough information about that. I have a matrix table with 6 measures. it changes by category. My matrix table looks like that Categ...
Need Help
  • v-chuncz-msft's avatar
    v-chuncz-msft
    7 years ago

    Anonymous,

     

    Add a seperate table that contains column names in one column, then drag the column to Columns, measure below to Values.

    Measure =
SWITCH ( SELECTEDVALUE ( Table2[Column1] ), "M1", [M1], "M2", [M2] )
v-chuncz-msft's avatar
v-chuncz-msft
Community Support
7 years ago

Anonymous,

 

Add a seperate table that contains column names in one column, then drag the column to Columns, measure below to Values.

Measure =
SWITCH ( SELECTEDVALUE ( Table2[Column1] ), "M1", [M1], "M2", [M2] )