Format for hidden columns change when using slicer

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.