Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Dynamic Currency Formatting

Hi

 

I have a table with sales values for different countries. Is there a way to have dynamic currency formatting based on the country?

 

For example, if I select Sweden, the values will be in SEK. If I select the UK, the values will be in GBP, etc. I don't want to have this formatted as a text, because these values are used in the charts.

 

I think I saw a way to have it with Tabular Editor (calculation groups?) but cannot find the thread now...

Need Help

6 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Hi CNENFRNL 

       

      Not really. This helps to set up the proper format of the currency symbol (which is what I want), but it is changing the format to string/text (which is something I don't want). Therefore, it will not be working with charts... so will not be the case for me.

       

      thank you for the reply though.

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    HI Anonymous,

    So you mean you want to dynamic convert the current currency values based on current user? If this is a case, you need to create a currency table with different currency rates from a common currency type.

    Then you can write a measure formula to extract the currency type from filter and do the conversion of raw table records based on currency table rates. (notice: you can't current dynamic calculated column/table based on filter selections, they not response with filter/slier operations)

    BTW, you can also take a look at the following blog about dynamic currency converter:

    Building a Dynamic Currency Converter with Power BI 

    Regards,

    Xiaoxin Sheng

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Anonymous 

       

      thank you for the response. what I need is not the currency VALUE, but the currency SYMBOL. I already have a dynamic exchange rate and the value is shown properly based on the country selected. However, I want also this to show the correct currency symbol based on the country selected.

       

      Do you know how to do this?

      • Anonymous's avatar
        Anonymous
        Not applicable
        5 years ago

        HI Anonymous,

        AFAIK, power bi allows you to set table fields with custom display format and keeping raw field types, but it is impossible to use Dax formula/filter to affect/interaction with this custom format of table fields.

        Use custom format strings in Power BI Desktop 

        Perhaps you can consider adding a measure with a switch function to display different currency symbols based on filter effects.

        Regards,

        Xiaoxin Sheng