Forum Discussion
Solved
How dynamically change the currency symbol for summarisation fields?
We are facing a challenge applying dynamically the right currency symbol based on the currency field from the table. Using API, we are preparing the following table with information about purcha...
You could try using a calculation group (see article below). A calculation group gives you more control over formatting and doesn't convert the data type to text.
https://www.sqlbi.com/articles/controlling-format-strings-in-calculation-groups/
DataInsights
Super User
Super User
You could try using a calculation group (see article below). A calculation group gives you more control over formatting and doesn't convert the data type to text.
https://www.sqlbi.com/articles/controlling-format-strings-in-calculation-groups/
This solution works perfectly for my case.
Not the ideal, but completely different level working with Power BI
Some useful link who wants to learn more:
https://learn.microsoft.com/en-us/training/modules/create-calculation-groups/5-lab