Forum Discussion
Solved
Currency Help
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 table...
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
I'm appreciate it.
Thank a lot, it very helpful!