Forum Discussion

nks98's avatar
nks98
New Member
1 year ago
Solved

How to Automatically Update a Single-Select Slicer When Parent Slicer Changes?

Hi everyone, I have a Power BI report with two single-select slicers that are hierarchical: Regional Manager (RM) – Parent slicer Team Manager (TM) – Child slicer, dependent on the selected RM Is...
  • OwenAuger's avatar
    1 year ago

    Hi nks98 

    This is a general issue with the core slicer visuals unfortunately, sometimes called "sticky slicers". 

    Solutions I can suggest:

    • Use a technique with field parameters to "reset" the Team Manager slicer when the Regional Manager slicer is changed. The TM slicer should not filter the RM slicer (via edit interactions), and the RM slicer has to force a change in a field parameter containing copies of the TM column. 
    • Use a Chiclet Slicer for Team Manager (if you are happy with the appearance).
      • Again, the TM slicer should not filter the RM slicer.
      • The TM slicer (Chiclet) should have Forced selection enabled.

    Here's a small recording of the Chiclet Slicer version using Continent/Country. I used Chiclet slicers for both in this example but only the 2nd slicer needs to be Chiclet Slicer.

     

    Hopefully similar functionality comes to the core visuals soon!

    (The Force selection option on the newer core slicer visuals unfortunately doesn't work like the Chiclet slicer.)