How to hide null columns in matrix table

[Anonymous]

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

[v-chuncz-msft · Accepted solution]

@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] )

[PattemManohar]

@Anonymous Please make sure that you have unchecked the "Show Items with no data" option (under columns)

[Anonymous]

@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.

[PattemManohar]

@Anonymous You need to do that option setting for "Column" fields not for Values fields. Refer below:

[Anonymous]

Values which i use in values entry section, are calculation. I can't use them on columns. Is there another solution for this ?

[PattemManohar]

@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.

[Anonymous]

 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.