Formatting Chart Labels as Currency

aadavis2890 · 2020-06-09T13:04:53.045Z

Hi y’all,

I am attempting to visualize sales data over a specified interval of time. The chart is populating correctly, but I want to alter the y-axis label as a currency, rather than as a number (I was $1,000,000 and not 1000000). When I try formatting the numbers as a currency, an error arises. I hope y’all might have a workaround for this issue. Thank you for your help.

Screenshot_2020-06-09 Bubble Editor - Omniliftv01(1)416×730 23 KB

// The above image’s error reads: “formatted as text.”

Screenshot_2020-06-09 Bubble Editor - Omniliftv01
// These are the formatting preferences I’ve stated.

Screenshot_2020-06-09 Bubble Editor - Omniliftv01(2)406×673 24.5 KB

// I’m working with daily sales records, so I grouped them by quarters.

alang.zul · 2022-06-16T06:06:22.818Z

any solution for this?

Sart · 2022-06-16T06:35:11.991Z

Hey @aadavis2890 ,

i have some points as solutions. I have not used the charts till now.

in your database if have given ‘Currency’ as data type to WeeklySales then i don’t think it will need to be formatted here.
chack the ‘Customise tooltip number formating’, you will get the bellow options

img328×878 18 KB

try it.
I Hope this will help you.

Just let me know what are the results.

alang.zul · 2022-06-19T09:49:23.279Z

oh okay then to need format in database as currency

Sart · 2022-06-20T08:13:21.703Z

hey @alang.zul ,
did it work for you??

corey1 · 2023-09-19T20:29:56.420Z

This makes the change to the amount in the graph but not the Y Axis. Anyone know how to change the Y-axis?