Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
2 years ago
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...
  • collinsg's avatar
    collinsg
    2 years ago

    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

collinsg's avatar
collinsg
Solution Sage
2 years ago

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