Is it possible to change the number formatting on a graph/chart view?
The columns in my query don’t have decimal places and are formatted with commas but in the chart view its the opposite, no commas and 3 decimal places.
I’d also like to add a dollar sign but I realize that might not be possible
Can you please show your BAQ and dashboard so I can replicate the situation?
I replicated the dashboard and I got something like this:
It does show decimal places after the total quantities but I realized that the total amounts of every month in the chart are integer, does it happen to you too?
If not maybe could be something in your calculated formulas… you can try to convert the fields within the calculated field as well not just in the formatting section…
besides, I don’t really think that this is something that could be modified with Code in a customization.
I made sure all the fields were constrained to whole numbers but whenever I change the chart type to “Chart all Y’s” being true, then it puts decimals in
Have you tried a different chart view?, because when I set all Y’s it did changed my quantities to decimals but I noticed that with other chart views this does not happen.
