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 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

  • 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

2 Replies

  • 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