cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
janfcarl
Helper I
Helper I

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.

11 REPLIES 11
v-shex-msft
Community Support
Community Support

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

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.
Anonymous
Not 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.

 

Hi, 

 

the interaction parent -> child is "filter", and child -> parent is "none". Child should not filter parent values.

Anonymous
Not applicable

Then, in your data "Site 1" may exists in Org1 and Org2. Please check that as well. 

Hi LP28,

 

no, definitely not, I checked it.

Anonymous
Not applicable

I guess this is the default behaviour of the slicers in powerbi. The issue is also explained below.

 

https://community.powerbi.com/t5/Desktop/Cascading-slicer-retaining-previous-value/td-p/704215

 

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. 

Hi LP,

 

Thanks, I feared as much but thought there would be an option to turn it off.

Where can I get the custom slicer?

 

KR,

jan

Anonymous
Not applicable

  Capture1.JPG

 

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:

 

Capture1.JPG

 

 

amitchandak
Super User IV
Super User IV

@janfcarl , Have tried Hierarchical slicer from Feb 2020

https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-february-2020-feature-summary/#_Hierarchic...



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

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.

AUS_69
Frequent Visitor

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

Helpful resources

Announcements
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Get Ready for Power BI Dev Camp

Microsoft named a Leader in The Forrester Wave

Microsoft received the highest score of any vendor in both the strategy and current offering categories.

Get Ready for Power BI Dev Camp

Power BI Dev Camp - September 30th, 2021

Mark your calendars and join us for our next Power BI Dev Camp!

PowerPlatform 768x460.png

Microsoft Learn

Check out our new Discover Your Career Path blog post series and get all the details.

Top Solution Authors
Users online (1,331)