Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I'm having trouble with an R visual which correctly displays a pound sign, "£", when on my desktop. BUT, after publishing the report online all of the £ signs become "A£" (where the A has an accent).
I have tried using the unicode for £ sign "\u00A3" but the problem persists.
So my question is how does Power BI Online services envode characters from R scripts?
Bonus round:
Why is it different from desktop?
Does anyone have a solution?
Thanks,
Will
Hi @Anonymous,
Based on your description, I think you have stored currency as text, right?
If this is a case, please check below link to know if you have used any unsupported libraries.
R packages in the Power BI service
In addition, you can also take a look at below document which told about how to create the r visual.
Creating R visuals in the Power BI service
Regards,
Xiaoxin Sheng
Hi,
Thanks for your reply, sorry I missed it until now. It looks like the package I am using, 'scales' is supported by Power BI. I'm using the function dollar_format(prefix = "£") to set the pound sign. Alas I haven't found any details in the documentation.
This is a very frustrating issue! might just settle on GBP 😞
Thanks for your help,
Will
Hi @Anonymous,
I haven't found an effective solution to work through your issue, maybe you can try to submit a ticket for this or contact to power bi team...
Regards,
Xiaoxin Sheng
Might be a good idea, do you know how I raise a ticket / get in contact?
Thanks,
Will
HI @Anonymous,
>>Might be a good idea, do you know how I raise a ticket / get in contact?
You can check below link:
Regards,
Xiaoxin Sheng
Hey @Anonymous, did you end up getting a response or work-around for this? I'm having this same issue.
Hi there,
I'm afraid I was never given a solution but it actually started working out of the blue one day..
I know that's not very helpful but I can let you know exactly what I'm using.
library(scales)
Currency <- "\u00A3"
Format <- dollar_format(prefix = Currency)
Formatted_Value <- Format(number)
and now that is working. Hope it helps,
Will
User | Count |
---|---|
98 | |
91 | |
84 | |
73 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
66 |