Forum Discussion

Ale's avatar
Ale
Icon for Resolver II rankResolver 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
Mariusz's avatar
Mariusz
Icon for Community Champion rankCommunity Champion
6 years ago

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's avatar
    Ale
    Icon for Resolver II rankResolver II
    6 years ago

    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.