Multiple currency symbols in single column

[PNicholsonRS]

Hi there,

I am wondering if it is possible to display some values in a column as £ and some values in the same volume as $ (so formatted as Currency)?

This is because I have values which are each in their native currency value, but I want to just put their respective currency symbol in front of that value.

Does anyone know if this is possible in Power BI?

Thanks!

[Wimverh]

A bit more detail if you want it in 1 column

sample table:

Measure:

Amount format =
VAR _currency =
    MIN ( 'Table'[Currency] )
VAR _currencycount =
    DISTINCTCOUNT ( 'Table'[Currency] )
RETURN
    IF (
        _currencycount > 1,
        BLANK (),
        SWITCH (
            _currency,
            "EUR", FORMAT ( [Amount], "€ #" ),
            "DOLLAR", FORMAT ( [Amount], "$ #" ),
            "POUND", FORMAT ( [Amount], "£ #" ),
            FORMAT ( [Amount], "general" )
        )
    )

Result: Keep in mind to not summarize on total when you have multipe currency values. 
For that reason the _currencycount is calculated.

 

[amitchandak]

@PNicholsonRS , You can create a custom format string and do that

https://docs.microsoft.com/en-us/power-bi/desktop-custom-format-strings