Currency Symbols on visuals

[tiaandp]

Hi all

I have secusfully built a currency conversion table in my report with a measure to calculate the value in selected curency.
The user selects the currency they want to see on a slicer.
I then add the symbol to this result in a new measure.

The problem I am facing is to use this result on my visuals, in this case a donut chart.
(The user wants to see currency symbols on the visual not just the top of my report in the totals column and slicer)

Here us the Dax I used to add the currency symbol to the total in selected currency measure:

Value with currency =

    FORMAT([Value In Selected Currency],SELECTEDVALUE('Currency Conversion Rate'[symbol]) & "##.#0")
The problem is the result is a string 😞

Any advice?

[HoangHugo]

Hi

Use format "Currency" and choose type you want, link picture below

[tiaandp]

Hi @HoangHugo and @Tahreem24 
The problem is the user wants to change the currency using a slicer. 
So this will not work unfortunatly 😞

I forgot to mention this in the original post, but I added it in now.

[HoangHugo]

Hi try to use CURRENCY function to convert your string to currency number, like below

Value with currency =

CURRENCY (

    FORMAT([Value In Selected Currency],SELECTEDVALUE('Currency Conversion Rate'[symbol]) & "##.#0"))

[tiaandp]

Hi @HoangHugo it worked!

So it works for certain currencies but not others,
For instance it works for Dollars $ but not for Korian Won ₩
Any idea why?

[HoangHugo]

Maybe Power BI did not regconize your currency symboy? Where is Currency Symbol from?

[tiaandp]

I used a table with symbols I donwloaded. 

Even if I copy the ₩ symbol from a power bi table after setting currency to 

and do this:

CURRENCY("₩123")
It does not work but when changing to CURRENCY("$123") it works

[Tahreem24]

@tiaandp You can try to append the currency symbol by following below screen shot.
First select Column name on which you want to add Currency symbol  --> go to Column tools menu --> select the $ sign (any currency symbol as per your need)