R script visual displays "£" correctly on desktop but as "A£" when published

[Anonymous]

Hi all,

I have an R script visual which has its values in £s. On my desktop this displays perfectly correctly using the following code:

pound <- dollar_format(prefix = "£")

data$Value <- pound(data$Value)

After publishing this online however the "£" signs have been replaced with "A£" as shown below

Published Online                       On Desktop

Does anyone have any experience with this and/or know a solution?

Thanks,

Will

[BeardyGeorge]

came across a similar problem recently, and I think this webpage will be useful for debugging when this comes up for someone else http://www.i18nqa.com/debug/utf8-debug.html

[BeardyGeorge]

try using "\u00a3" instead of "£" in case it's some kind of text encoding thing

[Anonymous]

Hi George,

Thanks fro your reply, shortly after posting my problem I had the exact same thought and tried it out but unfortunately the problem persists. It worked perfectly on my desktop but not after publishing online.

I agree it must be some kind of encoding problem and online Power BI and desktop Power BI are doing things differently but I can't figure out a solution.

Thanks,

Will

[Anonymous]

Also worth noting that previously this value was measured in dollars with a "$" sign rather than a "£". This worked perfectly both online and on desktop so it's only the "£" sign which is causing trouble.