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 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:
Values which i use in values entry section, are calculation. I can't use them on columns. Is there another solution for this ?
- 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.