Hide button based on slicer choice

[Anonymous]

I have a slicer with four options. One of the options needs to have a unique button on one of the visuals, whereas the other three should not. How do I manage to hide the button when selecting all but that one specific filter?

[Pranar786]

But the request was to hide the button visual, if we use a card visual to hide how will the button actions work?

[rajendraongole1 · Accepted solution]

Hi @Anonymous - You need to create a DAX measure that returns a value indicating whether the button should be shown or hidden. For example, if your slicer has the options "Option 1," "Option 2," "Option 3," and "Option 4," and you want the button to only appear when "Option 1" is selected, the measure can look like this

ButtonVisibility =
IF (
SELECTEDVALUE(SlicerTable[Option]) = "Option 1",
1,
0
)

More details and reference links below:

https://exceleratorbi.com.au/show-or-hide-a-power-bi-visual-based-on-selection/

Create buttons in Power BI reports - Power BI | Microsoft Learn

How to create Show Hide Button in Power BI using Bookmark & Button (youtube.com)

Solved: Hide un Hide buttons Based on Data - Microsoft Fabric Community