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 Categ...
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 What you are using as "Column" headers ? Could you please post the screenshot of the Matrix properties pane completely. I can see only the values section in your screenshot. Also, screenshot of your data as well.
I can't send the data screenshot, what do you want to know about data, i can tell you
Values are measure.
Category and Category2 are Column.