Support for Multiple Currencies

As far as I can tell, Power BI has no built in support for multiple currencies.

I have a data source containing financial values that can be in any number of currencies. There is also another column in the same table which contains the currency short code, eg GBP, EUR, USD etc. So far I have tried

1. The default, which formatted the values based on my locale (an astonishingly short sighted option)
2. I looked for, and didn't find, the ability to format a Currency data type based on a column containing a currency short code.
3. I currently have set all my financial columns to be of type Fixed Decimal Number and set them to two decimal places (not brilliant, but okay for most currencies).

I did test a workaround on a card visualisation where I created a measure and summed up a set of values, and then used FORMAT with a format looked up based on the currency short code. This worked for the summation card value, but I realised it was no good doing this for all my financial values, as FORMAT produced a string, and this couldn't then be put on a matrix and have subtotals and totals automatically calculated.

How have others approached this, as support for multiple currencies seems a fairly common scenario?

Chris

PS Have just seen a similar idea here https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/32674258-change-currency-symbol-dynamically