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...
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.