Forum Discussion
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
Category M1 M2 M3 M4 M5 M6
3001 12 5 3 9
3002 19 7 2 6
3007 5 9 1 5
The M5 and M6 columns change by value, Sometimes they don't have value, sometimes have value. I want to hide theese columns when they don't have value. I want to hide them completely. Their headers shouldn't be view.
Is it possible or not ?
Thanks
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] )
7 Replies
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] )
Anonymous Please make sure that you have unchecked the "Show Items with no data" option (under columns)
PattemManohar there aren't a selection like "Show Items with no data" on my case. By the way in rows option there is a seleciton like that but in values, not.
Anonymous You need to do that option setting for "Column" fields not for Values fields. Refer below:
