Disable Slicers based on another Slicer's selection

[Anonymous]

Hello fellows,

We have a YTD slicers and Month slicers for the same set of data.

By Design once YTD is selected, Month slicers should not work anymore, but the UI is confusing for users, I often receive people query why the month slicer does not work and it turns out to be the YTD slicer is selected.

Is there a way to make month slicer to be visually disabled once the YTD override selected "By Year to Date"?

Best regards,

[PPD]

Hi @parry2k , I tried your solution, and it works partially for me. If I select Month (e.g.  Jan 21),and want to go back to Year (or Quarter in my scenario), the month filter (Jan 2021) remains selected, and Quarter - Q1 option is available (instead of showing all quarters). I need to unselect the Jan 2021 month selection, everytime I want to select Quarter or Year filters. Am I  doing something wrong?

[parry2k]

@Anonymous Thanks for the feedback. Glad it worked for you. Cheers!!

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.⚡

[parry2k · Accepted solution]

@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.⚡

[Kazagha]

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. 

[Anonymous]

Super underrated answer!
Super clever!!