topic Re: GBP Pound sign in measure not working, but US dollar is working in DAX Commands and Tips

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

EMSSS22 — Fri, 16 Jun 2023 09:24:04 GMT

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")

When changed to £ sign:

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

eliasayyy — Fri, 16 Jun 2023 11:13:59 GMT

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

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

EMSSS22 — Fri, 16 Jun 2023 11:23:08 GMT

Same formula but pound sign

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

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

eliasayyy — Fri, 16 Jun 2023 11:43:39 GMT

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")

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

EMSSS22 — Mon, 19 Jun 2023 10:39:41 GMT

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