Forum Discussion

pickingapples's avatar
pickingapples
Frequent Visitor
9 months ago
Solved

How to make Slicers sync with one

I have one page with 3 sections, and each section has visuals that use its own slicer: MTD Section: slicer uses FY → Fiscal Quarter → Month Quarter Section: slicer uses FY → Fiscal Quarter Y...
  • burakkaragoz's avatar
    9 months ago

    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.