Forum Discussion
Hide button based on slicer choice
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?
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
2 Replies
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