Forum Discussion
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 SE...
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