Forum Discussion

Icon for Helper I rank

Helper I

6 years ago

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 Prob...

Anonymous

Not applicable

6 years ago

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

Icon for Helper I rank

Helper I

6 years ago

Hi LP28,

no, definitely not, I checked it.

Anonymous
Not applicable
6 years ago
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.
- janfcarl
  Helper I
  6 years ago
  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
    6 years ago
    
    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: