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
v-lili6-msft's avatar
v-lili6-msft
Icon for Community Support rankCommunity Support
7 years ago

HI, Anonymous 

I have tested on my side, but not reproduce the issue.

Could you share some screenshots with the explanation? It's better you could share a simple sample pbix file.

 

Best Regards,

Lin

 

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Interesting question, would love to help you but i need more info.

     

    Could you please recreate the issue in a PBIX file without corporate sensitive data? 

  • 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