Forum Discussion

Ale's avatar
Ale
Resolver II
6 years ago

Create dynamic single select slicer based on another slicer

First of all, I already tried approaches from old topics, but none of them worked.   I have a single data table that contains all my data including the 2 fields: Country and Currency.   Both fiel...
Need Help
v-juanli-msft's avatar
v-juanli-msft
Community Support
6 years ago

Hi Ale 

It seems you set the silcers to ignore each other.

Please see this documents how to change the interactioms between visuals in Power BI.

Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Ale's avatar
Ale
Resolver II
6 years ago

Hi Maggie,

 

thanks for your answer. Yes, I had to switch off the interaction between the 2 slicers because otherwise the currency slicer would impact the country slicer (when USD is selected, we would see only US, when in fact, I want to see all countries always).

 

However, removing this interaction created this issue I'm having now. Even though I can see all countries, once I select one of them, I get the wrong currency.