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?
A bit more detail if you want it in 1 columnsample table:
Amount format =
VAR _currency =
MIN ( 'Table'[Currency] )
VAR _currencycount =
DISTINCTCOUNT ( 'Table'[Currency] )
_currencycount > 1,
"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.
@PNicholsonRS , You can create a custom format string and do that
Proud to be a Super User!
Check out new user group experience and if you are a leader please create your group!
Check out how to claim yours today!
Test your skills now with the Cloud Skills Challenge.