The issue of correlation between two slicers

[xiaoxuesheng123]

In the Power BI data source, there is a "Year" column with values for 2021, 2022, 2023, 2024, 2025, and 2026.

Currently, there are two slicers on the report:

1. Slicer1 (Dropdown): This slicer only shows years less than 2025, i.e., 2021–2024. This is achieved by using the "Filters on this visual" section with advanced filtering and setting "is less than 2025".

2. Slicer2 (Tile): This slicer only shows 2025 and 2026 (for easy click selection, rather than needing to choose from a dropdown). This can also be set using the same filter method as slicer1.

The Issue:

• When a user selects a year in slicer1, for example 2022, the other visuals on the report display data for the selected year (2022).
• Then, when selecting a year in slicer2, for example 2024, slicer1 should clear its previous selection, but still display the years 2021–2024 in the dropdown, rather than showing nothing.
• Similarly, when selecting a value in slicer2 and then selecting a value in slicer1, slicer2 should still display 2024 and 2025 but the selection should be cleared.

I have been trying for several days with GPT and still couldn't find a solution.

Please only reply if you have verified the solution yourself, as I have already tried many AI-generated answers, and none of them worked.

[Anonymous]

Hi @xiaoxuesheng123 ,

Thanks for reaching out. I think I fully understand your requirements because of your detailed description.

For your needs, under my tests, you can only implement part of it.

I can realize that after slicer 1 is selected, when slicer 2 is selected, the result of slicer 2 is displayed. But there is currently no way to clear the option of slicer 1. Unless you can try the bookmarking feature, but it's not the perfect fit for your needs.

You can create the following measure as the visual-level filter.

MEASURE =
IF (
    ISFILTERED ( 'Slicer1 (Dropdown)'[Year] )
        && NOT ( ISFILTERED ( 'Slicer2 (Tile)'[Year] ) )
            && MAX ( 'Main Table'[Year] ) IN ALLSELECTED ( 'Slicer1 (Dropdown)'[Year] ),
    1,
    IF (
        ISFILTERED ( 'Slicer1 (Dropdown)'[Year] )
            && ISFILTERED ( 'Slicer2 (Tile)'[Year] )
            && MAX ( 'Main Table'[Year] ) IN ALLSELECTED ( 'Slicer2 (Tile)'[Year] ),
        1,
        IF (
            NOT ( ISFILTERED ( 'Slicer1 (Dropdown)'[Year] ) )
                && NOT ( ISFILTERED ( 'Slicer2 (Tile)'[Year] ) ),
            1
        )
    )
)

 When your Slicer 1 selects 2022, the table shows the data for 2022.

When your Slicer 2 selects 2025, the selection of Slicer 1 is ignored and the data for 2025 is displayed.

Hope it helps.

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[uzuntasgokberk]

Hello @xiaoxuesheng123 ,

There is an edit interactions in Power BI. İf you would like not to filter other slicer you need to select "None" in your edit interaction. Below the link explains detaily.
https://learn.microsoft.com/en-us/power-bi/create-reports/service-reports-visual-interactions?tabs=p...

Kind Regards,
Gökberk Uzuntaş

📌 If this post helps, then please consider Accepting it as a solution and giving Kudos — it helps other members find answers faster!

🔗 Stay Connected:
📘 Medium |
📺 YouTube |
💼 LinkedIn |
📷 Instagram |
🐦 X |
👽 Reddit |
🌐 Website |
🎵 TikTok |

[xiaoxuesheng123]

Thanks for your comment.

Actually interaction mode willl not solve this problem because it'll not clear selection.