I have two single select slicers, one of them ("parent") is filtering the other ("child").
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.
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.
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.
I guess this is the default behaviour of the slicers in powerbi. The issue is also explained below.
This is due to the child value is manually selected before changing selection in Parent slicer.
I tried an alternative by importing custom visual "HierarchySlicer". It works good. You can try.
you can click on the ... 3dots from the Visualizations and go to get more visuals and look for Hierarchyslicer. This adds a new visual and then you can add your slicer values in this like below example:
@janfcarl , Have tried Hierarchical slicer from Feb 2020
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.
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 ?
Check out the News & Announcements to learn more.
Microsoft received the highest score of any vendor in both the strategy and current offering categories.
Mark your calendars and join us for our next Power BI Dev Camp!
Check out our new Discover Your Career Path blog post series and get all the details.