Forum Discussion
Format for hidden columns change when using slicer
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
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.
1 Reply
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.