To show currency change value in Visuals according to change currency from Controls ( currency Filter )

Question & Answer
,
1

how to show currency values in visuals, when changing currency from filter.

  • I have multiple visuals that show amounts in $, but I have a filter which is having EUR, GBP, AUD, JPY, NZD, etc.
  • when I click on EUR from the filter, then all values in the visuals should show EUR converted value.
  • The same should be true for other Currencies like GBP, AUD, JPY, etc.

is it possible in Quicksight? please advice.

2

Hi @rajmohansingh
You need to create a parameter for the currency.
The a calculated field to calculate the value.

Ifelse(parameter=EUR,value*x, parameter=GBP, value*y,...., value)

BR

1 Like