Visualization (Buttons and Slicers)

[aziffarhan]

Hi everyone!
I'm currently working on an interactive Power BI dashboard and I’ve run into a challenge. I want to include slicers and buttons that allow users to filter by Year, Quarter, and Month.
My goal is to make the experience smooth and conflict-free — for example, avoiding situations where selecting Q1 and August (which belongs to Q3) results in no data.
I’ve tried using bookmarks to toggle between different slicer views, but I’m finding it a bit confusing to manage, especially since there are already quite a few bookmarks involved in the report.

Has anyone implemented something similar? What’s the best way to structure this so users don’t get confused or end up with conflicting filters?
Any tips on DAX logic, slicer design, or UX best practices would be greatly appreciated!

[aziffarhan]

Hi everyone.

There are a few things I still need help with.

Firstly, all the columns I’m using are from the same table. I’ve already created a Date Hierarchy consisting of Year, Quarter, Month, and Day.

What I’d like to achieve is the following behavior:

• When a user selects a Quarter (e.g., Q2), the respective Months within that quarter — April, May, and June — should also be automatically selected or highlighted.
• Similarly, when a user selects a Month (e.g., June), the corresponding Quarter (in this case, Q2) should also be selected or highlighted, even if only one month from that quarter is selected.

Is there a way to implement this kind of synchronized selection behavior in Power BI? I’d really appreciate any guidance or suggestions you guys can offer.

Thanks again!