Forum Discussion
Dynamic Currency Formatting
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
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?
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
This is correct, I can do this. But it will format the numeric values to strings and will not work with charts.
thank you for your help though.