set slicer value to dynamically grayed out based on a selection in another slicer

[Anonymous]

Hi there,

I have two slicers, and I want to set the value of my second slicer to be grayed out for the user based on the selection made in the first slicer. So that user can see but can not click and select the value. I know how to can completely hide the values using the SelectedValue function, but I want it to be visible there but grayed out.

I know it is possible. Someone did it already, but I don't know how?

I appreciate your help on this.

[danextian · Accepted solution]

Hi @Anonymous ,

I don't think you can gray out values in the second slicer unless the colors are already gray. But you can definitely use a shape without a border and a color fill on top of that slicer so the user clicks the shape instead of the slicer.