Forum Discussion
Slicer keeps previous selected value after filtering
I have two single select slicers, one of them ("parent") is filtering the other ("child").
Example:
parent -> Organization 1 (Selected), Organization 2
child -> Site 1 (Selected), Site 2
Problem is when I change parent to "Organization 2", the child slicer is filtered (now shows Site 3, Site 4 as options),
but also keeps Site 1 selected. Is it possible to prevent this behaviour? It is very confusing for our customer.
The newly selected value should rather be Site 3, and Site 1 should disappear altogether from options.
13 Replies
- amitchandak
Super User
janfcarl , Have tried Hierarchical slicer from Feb 2020
- janfcarl
Helper I
Hi amitchandak,
thank you, I tried the hierarchy slicer, but it has one problem: if I select Organization 1, both Site 1 and Site 2 are selected by default (although they are formatted as "single select" and the slicer itself is "single select").
I do not want that. Instead, only Site 1 should be selected.
- AnonymousNot applicable
Hi janfcarl , amitchandak
Sorry to unearth this post after 1 year, have you found a solution for the "Single Select" in a slicer with Hierarchy ?
My goal is the same as you : I want users to select a single "Project", but for ordering/structural reasons, I have a parent level that is "Client".
The behavior when clicking on "Client" is that it selects all "Projects" belonging to that client. That's not what I call a "Single selection"!
How could I still have "ordered" / "in folder" list of Projects in single select mode, without the Client being selectable ?
Thanks
- AnonymousNot applicable
Hi,
Have you tried to "Edit Interactions" in the Visuals Tools Menu?
I guess the interaction from Parent to Child has been disable and hence its keeping the previously selected value.
- janfcarl
Helper I
Hi,
the interaction parent -> child is "filter", and child -> parent is "none". Child should not filter parent values.
- AnonymousNot applicable
Then, in your data "Site 1" may exists in Org1 and Org2. Please check that as well.
- AnonymousNot applicable
HI janfcarl,
Nope, current you can't use a slicer to dynamic change other filters' selections. (current selection will keep even if the selected item has been filtered by other filters)
Perhaps you can submit an idea about dynamic update slicers or you can create a bookmark to save default selection then use it to reset whole page slicer selections.
Regards,
Xiaoxin Sheng
- nasirMfeFrequent Visitor
is there any solution this in 2025?