Currency formatting in bar charts

Hi friends! 

I’m making a simple bar chart showing costs in the value label and for some reason the formatting gets completely thrown off. See pictures. I am already formatting these values in the LookML and it’s working for other visualisations. I can use a table calculation to format the number and it works but I don’t want to use this since I don’t always know what currency is coming through. In my LookML I’m using html to format the number. I’m both rounding it and adding K, M etc and adding the appropriate currency symbol.

fb6a64f8-835c-45d7-bb3d-13c29731049b.png

Looking pretty ugly, see the results for how I want it to be formatted. 

42678372-9d4d-4ecc-8ab9-3eae45f8a9d3.png

Working great in another visual. 

Anyone experienced the same and how did you solve it? Is it a bug and if so how do I escalate? 

Many thanks,

Elin

0 2 1,046
2 REPLIES 2
Top Labels in this Space