I have a numeric column in analysis which shows sales figures which are quite big some times in billions. I am working to show the sales on a graph.
I would like to show the figures in Millions like 250M, 450M etc.
When I use the format #,#.0,,M it shows the figures in millions but the vertical axis on the graph still shows the same big figures,. it dont condense them to Millions