cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
New Member

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

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.

Annotation 2020-05-23 143508.png

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Support
Community Support

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

Hi @hakarSaber 

 

Try something like this:

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

1.PNGCapture.PNG

PBix attached.

Community Support Team _ Dina Ye
If this post helps, then please consider Accept it as the solution to help the other members find it more
quickly.

View solution in original post

3 REPLIES 3
Highlighted
Resident Rockstar
Resident Rockstar

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

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? 

 


______________


Has this post solved your problem? Please mark it as a solution so that others can find it quickly and to let the community know your problem has been solved. 


If you found this post helpful, please give Kudos.


I work as a trainer and consultant for Microsoft 365, specialising in Power BI and Power Query. 


https://sites.google.com/site/allisonkennedycv

Highlighted
Super User IV
Super User IV

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

Highlighted
Community Support
Community Support

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

Hi @hakarSaber 

 

Try something like this:

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

1.PNGCapture.PNG

PBix attached.

Community Support Team _ Dina Ye
If this post helps, then please consider Accept it as the solution to help the other members find it more
quickly.

View solution in original post

Helpful resources

Announcements
Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Using the Community

Using the Community

Need help with the Power BI Community? Our 'Using the Community' support articles are a great place to start.

Community Summit North America

Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Power Platform 2020 release wave 2 plan

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors