Format for hidden columns change when using slicer

[HEW]

Hi.

I have a matrix, where I have the monthly figures and a running total. For the different categories I would like to show the monthly figures and for the total I would like to show the running total. I am able to "hide" the columns by setting auto-size to off and then dragging the columns. However, when I change the employee I would like to see (slicer) the format changes and the hidden columns are partly visible.

How can I solve this? It doesn't look very nice. The first matrix is correct and the second shows my problem.

Thanks a lot.

Helen

[Anonymous · Accepted solution]

Hi @HEW ,

I created a simply data sample to test:

To my knowledge, since there is no option to dynamically hide fields based on a slicer, you may use Conditional Formatting to keep the font color to make it look like hidden:

change sum color = IF(MAX('ForSlicer'[Value])="sum","Black","White")

change average color = IF(MAX('ForSlicer'[Value])="average","Black","White")

Or create a new table for slicer firstly, and then use SWITCH() to match the measures like:

ForSlicer = {"sum","average"} 

Measure = SWITCH(MAX('ForSlicer'[Value]),"sum",[sum],"average",[average])

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