Forum Discussion
How to Automatically Update a Single-Select Slicer When Parent Slicer Changes?
- 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.
- Blog post by Matt Allington
(you may need to use a plugin such as Just Read for reader view as the site is displaying oddly at the moment). - Video on same method
- Blog post by Matt Allington
- 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.)
- 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.
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.
- Blog post by Matt Allington
(you may need to use a plugin such as Just Read for reader view as the site is displaying oddly at the moment). - Video on same method
- Blog post by Matt Allington
- 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.)