Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Cascading slicer retaining previous value

Hello Experts, I have a scenario which is creating a big problem Scenario : I have two columns from same table 1. Geo Level :  Values [ Nation, Region, Division, Territory] 2. Geo  Name: Dependi...
General Comment
Interesting Links
Need Help
Show and Tell
Tips and Tricks
Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi,

 

Thanks for your quick response, one point to note is we have applied security and the relationship is in both direction..

 

Thanks

v-lili6-msft's avatar
v-lili6-msft
Icon for Community Support rankCommunity Support
7 years ago

hi, Anonymous 

I have test on your file, It is not a bug issue,

When you select the value in one slicer, when you click on any other visual(include slicer).

the selected value of this slicer won't be changed, even if you edit interaction of them.

In your case, when you select Nation first and select India again. the Region shouldn't appear in the first slicer, so you use edit interaction of them to keep first slicer won't be interacted. But even so, when you change the value of first slicer to Region, the second slicer selected value still keep India and it is available before it is changed manually.

 

 

Best Regards,

Lin