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,
@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.
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?
@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.
@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.
Helpful resources
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.
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!
Business Application LATAM Summit 2023
Join the biggest FREE Business Applications Event in LATAM this February.
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.
