Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Disable Slicers based on another Slicer's selection

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...
Need Help
  • parry2k's avatar
    parry2k
    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.⚡

     

PPD's avatar
PPD
Icon for Helper I rankHelper I
5 years ago

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?