Forum Discussion
Hide slicer based on the value
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!
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.
2 Replies
- MattAllington
Community Champion
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/ 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.
