Change each value in cell to its respective currency

[Anonymous]

Hi all,

I have a small data set of value,

Location	Cost
PNG	26 MYR
JPN	88 YEN
BBU	100 EURO

And I want to put the respective currency symbol in my report for each of the value. I do tried some steps back then but all value are stated in EURO. Is it possible to do this? Thank you.

[Jihwan_Kim]

Hi, @Anonymous 

I am not sure how your data model looks like, but please check the below.

It is one of the many ways to just add currency symbols. 

Cost Total with Currency =

IF (

ISFILTERED ( 'Locations Info'[Location] ),

SUMX ( Costs, Costs[Cost] ) & " "

& SELECTEDVALUE ( 'Locations Info'[Currency] )

)

https://www.dropbox.com/s/p36jhfj4a7nrk9r/afqhumrh.pbix?dl=0 

Hi, My name is Jihwan Kim.

If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

Linkedin: linkedin.com/in/jihwankim1975/

Twitter: twitter.com/Jihwan_JHKIM

[OwenAuger]

Hi @Anonymous 

I would actually recommend using a Calculation Group with a format string conditional on the selected currency.

This article covers a similar situation.

I have attached a PBIX illustrating how you could set this up.

1. First I structured the data so that there is a column containing the currency name separately from the value.

2. Then I created a Calculation Group called "Number Format", with a single Calculation Item "Currency Format". This Calculation Item has

• Expression: SELECTEDMEASURE()
• Format String Expression that depends on the selected currency (may need tweaking):

VAR ExistingFormatString = 
    SELECTEDMEASUREFORMATSTRING ()
VAR SelectedCurrency = 
    SELECTEDVALUE ( Cost[Currency] )
VAR CurrencySymbol = 
    SWITCH ( 
        SelectedCurrency,
        "EURO", """€""",
        "YEN", """¥""",
        "MYR", """RM""",
        "" -- default to no symbol
    )
VAR NumberFormat = 
     CurrencySymbol & ExistingFormatString
RETURN
    NumberFormat​

3. Then if you filter on this Calculation Item in the report, the numbers are formatted appropriately in the case of a single currency. If multiple currencies are summed (should be avoided) then the symbol is omitted.

Regards,

Owen