Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Anonymous
Not applicable

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 receive people query why the month slicer does not work and it turns out to be the YTD slicer is selected.

hsy_0-1610313779732.png

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

 

Best regards,

 

1 ACCEPTED SOLUTION
parry2k
Super User
Super User

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

 



Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤


Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

View solution in original post

5 REPLIES 5
PPD
Helper I
Helper I

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?

 

 

Capture.PNG

parry2k
Super User
Super User

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



Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤


Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

parry2k
Super User
Super User

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

 



Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤


Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

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
Not applicable

Super underrated answer!
Super clever!!

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.