Dynamically change in currency symbol after currency selection in slicer

[Anonymous]

Hi, 

I currently have a report where I convert from multiple currencies back to our base and other currencies. 

So user in europe can look at the report in Euro, U.S. in $, U.K. in £ and so on so forth.

This works fine and I am able with dax to output the correct conversion amount. 

However I need the charts to oupt the values with their corresponding currency symbols. 

I was considering using DAX FORMAT method but this outputs the value as a string and I end up with a count of these string values rather than a sum. 

I can obviously set the column to a specific currency using the modelling section in Desktop but that is static. I needs to change as the user switches the currency with on slicers on the page.

Thanks in Advance,

Mayur Kanawade

[Anonymous]

hi,

this is not working in my case .. The client wants to see badget(local+international)on  dasboard with a switch option between INR and Dollar as per  change  in value of dollar on daily basis.p.

Thanks

[monty187]

Hi guys

I have been working on some powerbi reports where the user wants the number format to be displayed on charts depending on the currency selected. When using the method above, the number is converted to text and therefore doesnt work on charts.

Is there a way to switch currency with a slicer, and use the output measures on charts (displaying the currency formatted number on the chart)

Thanks

Michael

[Krishnan_47]

I am also facing the same issue, wanted to know if you have got a workaround for this.

[v-lili6-msft]

hi, @Anonymous 

First, you should know that calculated column and calculate table can't be affected by any slicer. you could create a measure
Notice:
1. Calculation column/table not support dynamic changed based on filter or slicer.
2. Measure can be affected by filter/slicer, so you can use it to get dynamic summary result.
here is reference:
https://community.powerbi.com/t5/Desktop/Different-between-calculated-column-and-measure-Using-SUM/t...
https://www.sqlbi.com/articles/calculated-columns-and-measures-in-dax/

Second, you could try this way as below:

Step1:

Add a currency symbol table for slicer.

Step2:

For the simple example, this is my basic measure for sum value

TOTALAmount = CALCULATE(SUM(Data[Amount] ))

Step3:

Use SELECTEDVALUE Function and FORMAT Function to add a dynamically change currency symbol measure

Measure = SWITCH(TRUE(),
SELECTEDVALUE('currency'[Type])="Euro", FORMAT([TOTALAmount],"€#,##0"),
SELECTEDVALUE('currency'[Type])="U.S.", FORMAT([TOTALAmount],"$#,##0"),
SELECTEDVALUE('currency'[Type])="U.K.", FORMAT([TOTALAmount],"£#,##0"),
[TOTALAmount])

Result:

and here is a sample pbix file, please try it.

Best Regards,
Lin

[parry2k]

@Anonymous you are on right path, you need to sum first and then use DAX Format to add currency symbol and then it will work.