cancel
Showing results for 
Search instead for 
Did you mean: 
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.

 






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

4 REPLIES 4
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.






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.

 






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.





Anonymous
Not applicable

Super underrated answer!
Super clever!!

Helpful resources

Announcements
Carousel_PBI_Wave1

2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.

Power BI Summit Carousel 2

Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!

BizApps LATAM 2023

Business Application LATAM Summit 2023

Join the biggest FREE Business Applications Event in LATAM this February.

Power Platform Bootcamp

Global Power Platform Bootcamp

In this bootcamp we will deep-dive into Microsoft’s Power Platform stack with hands-on sessions and labs, delivered to you by experts and community leaders.