Create dynamic single select slicer based on another slicer

[Ale]

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 fields are used as slicers on my report. However, the currency slicer has to be single select, as we can't show more than 1 currency at once (the report sums the values so we can't sum different currencies).

At the moment, this currency slicer assigns a default value which is EUR. However, when I select a Country like US, the value in the currency slicer still shows the EUR (as it was the "default" value), while the USD is shown as a 2nd option in the slicer. The problem is that once the country US is selected and the default currency is EUR, the report becomes all blank (even though there is no EUR for US, it does not update the currency slicer automatically). Then the user has to manually change the currency to USD - which appears as a 2nd option.

How can I make this currency slicer to be dynamic, so whenever a country is selected, the correct currency is shown? Important: if multiple countries are selected, then we should see all the possible currencies, but only 1 can be selected at once.

[v-juanli-msft]

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]

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.

[Mariusz]

Hi @Ale 

I don't think you can achieve this kind of behaviour with a slicer as its stands, my suggestion would be creating one measure for local currency that dynamically switches and a second measure that does the conversion to the selected currency.

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

[Ale]

Thanks for the answer, Mariusz. I'm not trying to convert the value. I just want to show the corresponding currency for the country that is selected. It just doesn't work with the Single Select slicer because it always keep a standard default value.

I tried to create a measure but it didn't work well. The measure should return a list of values, so to say, as multiple countries could be selected at the same time. Then the currency slicer should show different currencies, but only 1 selected. The problem is just that the single select slicer seems to always keep memory on the last value selected. It does not change automatically based on other slicers/measures.