cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
PNicholsonRS
New Member

Multiple currency symbols in single column

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!

2 REPLIES 2
Wimverh
Resolver II
Resolver II

A bit more detail if you want it in 1 column

sample table:
2020-04-29_14-50-59.jpg

 

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.

2020-04-29_14-49-53.jpg 

amitchandak
Super User IV
Super User IV

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

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



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are You Ready?

Test your skills now with the Cloud Skills Challenge.

Top Solution Authors