Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get inspired! Check out the entries from the Power BI DataViz World Championships preliminary rounds and give kudos to your favorites. View the vizzies.

Reply
EMSSS22
Helper I
Helper I

GBP Pound sign in measure not working, but US dollar is working

Hi,

 

I am trying to combine some values to create a label for a chart that I have. I have tried to add in a GBP sign but it just gives me a mix of letters and numbers, yet when I change it dollar sign it works. Is there a reason for this? Or a workaround??

 

Dax Measure used: 

DataLabel = FIRSTNONBLANK(Merge1[New TOC - Copy], "") & " $" & FORMAT(SUM(Merge1[Contracted and Uncontracted Value]),"#,##,,.0M")
 
EMSSS22_0-1686907354621.png

 

 When changed to £ sign:
 
EMSSS22_1-1686907402639.png

 

4 REPLIES 4
eliasayyy
Memorable Member
Memorable Member

can you show the measure you used with the gbp und? cause i tried it and it works no issues when i uses [measure] & "£"

Same formula but pound sign

 

DataLabel = FIRSTNONBLANK(Merge1[New TOC - Copy]"") & " £" & FORMAT(SUM(Merge1[Contracted and Uncontracted Value]),"#,##,,.0M")

that is weird it should work fine maybe try inserted the gbp pound in the format so you get 

DataLabel = FIRSTNONBLANK(Merge1[New TOC - Copy], "") & " " & FORMAT(SUM(Merge1[Contracted and Uncontracted Value]),"£#,##,,.0M")

Tried that, the same issue occurs... very strange

 

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code FABINSIDER for a $400 discount!

FebPBI_Carousel

Power BI Monthly Update - February 2025

Check out the February 2025 Power BI update to learn about new features.

March2025 Carousel

Fabric Community Update - March 2025

Find out what's new and trending in the Fabric community.