Dashboard isnt picking values with K or M

Gaurav Chauhan

Hi, I have a revenue data set in millions and thousands. I am able to convert them to K and M unit using formulae.

Now the irony is that this cannot be charted on the dashboard.

I wish to display the bar chart with value as 5.9M or 790K but the dashboard isnt working.

Any workaround. Please suggest.

Thanks.

Lucas Rayala

Hi @Gaurav Chauhan -- I would convert them all to million (M) but leave off the M -- if it's a number you can chart it. Note in your legend that the value is in millions.