Why power Bi slicers not refreshing in cascading selections!!!!!!!

[venkatnitt84]

I have a requirement where the slicers value need to get refreshed based on another slicer.

There is no problem with refreshing the values , But when a value is selected in Child slicer and then again if make another selection in parent slicer , the child slicers still retains the previously selected value even after the value gets refreshed

For eg.  consider 3 table Region (RCd) with values R1,R2  and District table (DCd) with values R1A,R1B,R2A,R2B and the dim tables connected to fact table

1) Select  R1 in the Rcd slicer , it will refresh values in Dcd slicer (Will show R1A, R1B) which is fine.

2) Now Select R1A in the DCd slicer, then select R2 in RCd slicer. It will show values correponding to R2(R2A,R2B) as well previously Selected R1A. power Bi holds the previously selected values instead of automatically removing previously selected value which is not applicable.

Is it a limitation with power BI?

[amitchandak · Accepted solution]

@venkatnitt84 ,

Can you check if a new Hierarchy slicer is a better option for you?

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

Search for -Hierarchical slicer (preview)

[venkatnitt84]

@amitchandak  - Thank You . It works. It refreshes with Herarchy slicer. Wish it had drop drown option. Anyways it looks far better than default slicers.

[Greg_Deckler]

Not sure I would characterize it as a limitation rather than that's just how it works. You selected a value in that child slicer. Power BI is not just going to wipe out your selection because you changed something somewhere else.

This is one of those darned if you do, darned if you don't kind of things. If they made it do what you want, there would be an equal number of people angry that it worked that way and not the way it currently operates.