How to show same value in two different currencies on a visualization?

[Anonymous]

Hello,

I have a clustered column chart that shows the revenue, but I want to show the values in two different currencies and give the user the ability to change the between them with a slicer. I currently have both values in same column and it is working as I want, but the issue is that I cannot change the data type of that column to hold both currencies, in this case when i choose the IQD it still shows the numbers with $ symbol. How can I solve that to show the values with their symbol?

Thank you.

[v-diye-msft · Accepted solution]

Hi @Anonymous 

Try something like this:

Add custom column if you don't have 2 columns , then unpivot them:

PBix attached.

[amitchandak]

@Anonymous ,

https://www.sqlbi.com/articles/currency-conversion-in-power-bi-reports/

https://blog.beyondimpactllc.com/blog/building-a-dynamic-currency-converter-with-power-bi

[AllisonKennedy]

As you said, you can't have two data formats or types for 1 column, so do solve this you have to get creative. Is there a reason you can't have two columns for the two currencies?