Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to 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
I'm appreciate it.
Thank a lot, it very helpful!
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