hide column when it is blank

[thanksforhelp22]

Hi, I need to hide one column but show its column total in Matrix visual. I am able to acheive when it just one value but when multiple values added it showing the column custom_measure even when it is blank, column hide should be based on the measure not grab and close the column manually. Here is my measure. I need to acheive table 2. thanks

[v-kongfanf-msft]

Hi @thanksforhelp22 ,

Then as @lbendlin said, you can raise a idea.

Best Regards,
Adamk Kong

[v-kongfanf-msft]

Hi @thanksforhelp22 ,

Thanks for the reply from @lbendlin , please allow me to provide another insight:

As you said, columns do not support hiding based on measure for now. It can only be hidden by column fields via show item with no data.

Best Regards,
Adamk Kong

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[thanksforhelp22]

no, this is not working for me

even removed column/row subtotal since it had data for custom_Measure

[lbendlin]

Not possible at the moment.

If this is important to you please consider voting for an existing idea or raising a new one at https://ideas.fabric.microsoft.com/?forum=2d80fd4a-16cb-4189-896b-e0dac5e08b41