How to Handle Currency symbol over charts and make it dynamically change based on the user selection

[abhilashyerasi]

There is a concrete solution if a user i using the tables in order to handle multiple currency types based on the user selection wither country or currency. 

Lets assume we have a column revenue which belong to different countries such as (India, Malaysia and Thailand). Planning to create a single daahboard for the users. 

Note: I am not going for any conversion as my revenue is been stored in the local currrency only.

Possible Solution through community found:

1. Formating the revenu which typically convers it into Text which can be utilised for charts.

2. Just add a statement in chart that what currency it belongs to (Plain Venella one)

3. Create multiple measures based on the number of countries in the data and populate using the stacked bar chart. It fails for the cases were we use cards in visuals.

Looking for a solution based on the user selection just the currency symbols gets added.

Thanks in Advance

[lbendlin]

"Note: I am not going for any conversion as my revenue is been stored in the local currrency only."

That's not a good enough reason. Consider using a conversion table.

[abhilashyerasi]

Thanks for reverting appreciated your efforts.

Based on my requriment i have the revenue in the local currency only. But the they are all avaiable in a single column only. 

Using Switch Fucntion based on user selection and formating the revenue based on selection is helpful only in table but not in charts.

Looking for function based on sleection currency sysmbols gets varyed.