Currency Help

[Syndicate_Admin]

Hello PBI Expert,

I have a report with parameters for sales, profit,.. And all are known as Vietnam Dong.

I want to convert VND to USD and vice versa with a slicer.

My problem is that all my tables have no information about currency or table about currency.

So should I create a table about currency then merge it into the main table or is there a way to do it?

Looking forward to the help.

Thank you

[Syndicate_Admin]

I'm appreciate it.

Thank a lot, it very helpful!

[collinsg · Accepted solution]

Good day KayzDo,

In this example I started with the sample semantic model available in Power BI Desktop, which has a single table "financials".

The procedure is as you suggest. Create a currency table. This can either be "by hand" or from an online source. Do not create a relationship between this table and "financials" - in other words it is a "disconnected" table.

Create a slicer visual for the Currency column of this table (configure it for single selection, just to be "tidy")

Now create a measure

Sum of Sales = SUM(financials[ Sales]) * SELECTEDVALUE('Table'[Conversion Factor])

When you place this measure in a visual it will use the currency you have selected.

Hope this helps