How to make Slicers sync with one

[pickingapples]

I have one page with 3 sections, and each section has visuals that use its own slicer:

1. MTD Section: slicer uses FY → Fiscal Quarter → Month

2. Quarter Section: slicer uses FY → Fiscal Quarter

3. YTD Section: slicer uses FY only
   
   

What I want it does:
I want the Quarter and YTD slicers to automatically follow whatever is selected in the MTD slicer.

For example:
If I select a specific month in the MTD slicer, the Quarter and FY slicers should automatically select the correct Quarter and Fiscal Year for that month.

This works only when the selected month is in the current month (e.g., in December, Quarter auto-selects Q4 and FY auto-selects FY26).

But if I select a month in Q3, the Quarter slicer only shows Q3 in the list and it does not select it, unless i select it manually.
Same issue for the FY slicer when I select a month that belongs to a different fiscal year.

Is there any recommended method on this?

[v-hashadapu]

Hi @pickingapples , Thank you for reaching out to the Microsoft Community Forum.

We find the answer shared by @burakkaragoz  is appropriate. Can you please confirm if the solution worked for you. It will help others with similar issues find the answer easily.

Thank you @burakkaragoz  for your valuable response.

[burakkaragoz · Accepted solution]

Hi @pickingapples ,

This is a very common frustration, but what you are seeing is actually the expected "Standard Behavior" of Power BI slicers.

The "Why": Slicers in Power BI are designed to filter the list of options, not to auto-click selections for you.

• When you select "Nov" in your MTD slicer, the underlying data is indeed filtered to Q3.

• The Quarter slicer reacts by hiding Q1, Q2, and Q4 (because they are no longer valid), leaving only Q3 visible.

• However, the slicer will not physically place a "check mark" or "radio button dot" on Q3 automatically. It just restricts the available choices.

The Solutions:

Since you cannot force a slicer to "auto-tick" based on another slicer, here are the two best ways to achieve your goal:

Option 1: Use Cards for Context (Recommended) If the goal of the Quarter and YTD slicers is just to show the user which period they are looking at, replace those slicers with Card Visuals.

• Create a measure: Current Quarter = SELECTEDVALUE('Date'[Fiscal Quarter], "Multiple Quarters")

• Create a measure: Current Year = SELECTEDVALUE('Date'[FY])

• Place these cards in your Quarter and YTD sections. When you pick "Nov", the cards will automatically update to say "Q3" and "FY26" textually.

Option 2: Single Hierarchy Slicer If you want the slicers to be interactive, having 3 separate slicers that fight for control is often confusing for users.

• Instead, use one single slicer with the full hierarchy (FY > Quarter > Month).

• When a user expands and selects "Nov", the parent levels (FY26 and Q3) are implicitly active, and the logic flows down naturally without needing "syncing" tricks.

Summary: The data is being filtered correctly (you will see your visuals update), but the "dot" won't appear on the secondary slicers. I recommend Option 1 to give your users clear feedback on where they are in time.

Hope this clarifies the behavior!

---

If my response resolved your query, kindly mark it as the Accepted Solution to assist others. Additionally, I would be grateful for a 'Kudos' if you found my response helpful.
This response was assisted by AI for translation and formatting purposes.