Forum Discussion

Pranavi's avatar
Pranavi
New Member
2 months ago
Solved

Cascading Slicers

Hello, so there's a report we built, it has 4 slicers all from the same table, and the main visual is a paginated report embedded into power bi desktop. Now the thing is, slicer 1 (main/parent) is a ...
  • Omkar_1712's avatar
    2 months ago

    Hello Pranavi,


    This is expected behavior in Power BI. While cascading slicers dynamically filter the available values in downstream slicers, they do not automatically clear existing selections when the parent slicer changes.


    For example, if users make selections under Parent = 'A' and then switch the parent slicer to 'B', the child slicers will retain their previous selections until they are manually cleared or reset.


    Some potential workarounds include:

    • Using a Reset Filters button with bookmarks.
    • Configuring Single Select where appropriate.
    • Reviewing the report design to simplify the filtering experience.

    At present, Power BI does not provide a native capability to automatically reset child slicers based on changes in a parent slicer selection.

    I hope this helps.

    Best regards,
    Omkar Shinde
    Microsoft Fabric Enthusiast | Power BI Consultant

    💡 If you found this response helpful, please consider giving it a Kudos.
    ✅ If this resolves your question, please mark it as the Accepted Solution to help others in the community.

  • parry2k's avatar
    2 months ago

    Pranavi one addition, you don't need a bookmark to clear slicer; you can use the built-in feature to clear slicers using a button action.