Dynamic color for slicer

[amikm]

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.

[PaulDBrown]

@amikm 

You could as a workaround use a table visual instead of a slicer visual (not ideal, but..)

[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

[amikm]

Hi @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

[Mariusz]

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]

I agree with @Mariusz , I logged an issue for the same and it got rejected saying it is the default behavior