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,
As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided for the issue worked? or Let us know if you need any further assistance?
If our response addressed, please mark it as Accept as solution and click Yes if you found it helpful.
Regards,
B Manikanteswara Reddy