150 votesScott Ho commented
I am currently developing a Sales report for a multi-national company who has shops from around the world. The Headquarters in Europe wants to see Sales reports in EUR as that's what makes sense to them. However, a big share of the retail revenue is coming from Australia in transaction currency in AUD. Headquarters also fixes the exchange rates that we need to use for reporting purposes. The daily currency market movement is irrelevant as financially reporting is done only monthly. I didn't want to create two different measures like Actual MTD and Actual MTD (EUR). I preferred to use only one measure called Actual MTD.
When we deal with currencies, we always talk currency value and symbol to make sense. So naturally I had to add two parameters and control the calculation and DISPLAY of the Actual MTD:
ShowEuroCurrencyValue = TRUE
ShowEuroCurrencySymbol = TRUE
But the second parameter would expose this Power BI limitation in formatting (converting numeric to text). The solution I came up is instead of changing the format on the measure itself, I had to add a Card on the page at the top to show viewers either AUD or EUR.
ScottScott Ho supported this idea ·