Forum Discussion
Conditionally show or not show a numeric paramter slicer
I have a slicer to input data:
I only want it to be enabled when I select "Show" in the slicer:
I wrote a DAX and dragged it to the filter of the numeric slicer and set it to "1" but it didn't work:
3 Replies
- parry2k
Super User
Silvia_Gulu maybe you want to use techniques shown in these videos:
Color transparency and conditional formatting is VERY powerful Part 1 - Power BI (youtube.com)
- suparnababu8
Super User
Hi Silvia_Gulu
Try with this
ConditionalShowOrNoShow = IF(SELECTEDVALUE(Show_no_show[Show or no show]) = "Show",1, BLANK() )Apply the ConditionalShowOrNoShow measure as a visual-level filter on the slicer you want to conditionally enable. Set the filter condition to is not blank.
- AnonymousNot applicable
Hi Silvia_Gulu ,
You can use bookmarks to control its visibility, you need to use the book navigator to do so.
Create page and bookmark navigators - Power BI | Microsoft Learn
Hope it helps!
Best regards,
Community Support Team_ Scott ChangIf this post helps then please consider Accept it as the solution to help the other members find it more quickly.