Forum Discussion
Helper VDynamic color for slicer
Hi All,
I am trying to achieve this in one of my reports. the scenario is -
I have a column say TrafficLight which has three values (1,2,3) and I am using that column as a slicer
I want to assign the color for 1, 2, and 3 as Red, Yellow, and Green.
When the user select 1 from the slicer color should become Red and 2 and 3 will be grayed out
Similarly when users select 2 from the slicer the color of 2 should become Yellow and 1 and 3 can be grayed out.
Same when users select 3 from slicer the color of 3 should be Green and 1 and 2 can be grayed out.
5 Replies
- Mariusz
Community Champion
Hi amikm
Please see the attached file with a solution.
However, when using a slicer or visual you can only apply the formating to another visual ( you can not modify the visual that you have used to select values in, to my knowledge )
Best Regards,
Mariusz
If this post helps, then please consider Accepting it as the solution.
Please feel free to connect with me.
LinkedIn
- amitchandak
Super User
I agree with Mariusz , I logged an issue for the same and it got rejected saying it is the default behavior
- Mariusz
Hi amikm
But you can combine slicer ( set background transparency to 100% ) with rectangle/shape object and apply conditional formatting there, please see the attached.
Best Regards,
Mariusz
If this post helps, then please consider Accepting it as the solution.
Please feel free to connect with me.
LinkedIn
amikmHi Mariusz,
Thanks for your workaround on conditional formatting for Slicer.
Suppose we have thee colors Red, Green, and Yellow and I am using that as a horizontal slicer.If I click on Green, the color of the Selected slicer should change to Green and the Other two colors will be grayed out.
Same behavior with Red and Yellow selection I am looking for.Currently, you can see the background color is Black (which is the default behavior)
Amit
PaulDBrown
