Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
akuttler
Creator
Creator

Chart Custom Number Formatting

How to change "9,324,794.00 " to "9.32M "??

2 Replies
petter
Partner - Champion III
Partner - Champion III

Num( Amount / 1000000 , '0.00M','.',',')

jaimeaguilar
Partner - Specialist II
Partner - Specialist II

Hi,

Chart properties > Data > select your measure > Change number formatting from "auto" to number for example and use the drop down menu to select your desired format. You can also use the custom format, but then you'll need to type the format function like "num(Field, '#,##0')

regards