Forum Discussion
Resolver IICreate dynamic single select slicer based on another slicer
Community ChampionHi 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.
Mariusz
If this post helps, then please consider Accepting it as the solution.
Resolver IIThanks 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.