Hide slicer based on the value

[Anonymous]

Hello,

I have created a measure that has value = 1, if user does select a row in the table or bubble on the map and value = 0, if the table or map is not selected.

Based on this value I would like to hide or make the Tile Slicer not clickable when it's 1, and allow users to change the value in the Slicer when the value is 0.

I would be grateful if you could please support me with some clever idea. I tried to display the shape in the background color to hide the Slicer behind it, but I struggle to send it backward to enable the usage of slicer.

Thanks!

[Anonymous · Accepted solution]

Hi @Anonymous ,

I can give you a sample:
Here is my sample data:

I don't know what is your measure, So I'll use this measure instead:

Measure = SELECTEDVALUE('Table'[1 & 0])

Then use this DAX to create a measure:

Measure 2 = 
IF(
    [Measure] = 0,
    1,
    0
)

Make the settings as shown in the following figure:

The final output is as below:

Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[MattAllington]

Slicers are hard because whatever you put over the top will prevent you clicking the slicer. This article may give you some ideas or inspiration. 
https://exceleratorbi.com.au/show-or-hide-a-power-bi-visual-based-on-selection/