Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
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:
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
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 13 | |
| 5 | |
| 5 | |
| 3 | |
| 3 |
| User | Count |
|---|---|
| 25 | |
| 10 | |
| 10 | |
| 6 | |
| 6 |