Forum Discussion
Disable Slicers based on another Slicer's selection
- 5 years ago
Anonymous there is no disable concept but you can use visual level filter for slicers. see attached, change it as per your need.
Check my latest blog post Year-2020, Pandemic, Power BI and Beyond to get a summary of my favourite Power BI feature releases in 2020
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡
Anonymous there is no disable concept but you can use visual level filter for slicers. see attached, change it as per your need.
Check my latest blog post Year-2020, Pandemic, Power BI and Beyond to get a summary of my favourite Power BI feature releases in 2020
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡
Good thinking, this may be a useful tool.
I am creating a report with a 'advanced filters' section as a separate page, and using a 'page navigation' button for the user to open the filters page. The issue is some filters are not relevant to all pages.
Possibly using a Bookmark to select the relevant filter option, and navigate to the filters page. This would allow slicers to be selectively disabeld. Needs testing to determine how much work it will be to maintain.
Thank-you for the idea.