In many visualizations you can control how the numeric types are formatted. You control the format by supplying a format string. That formatting applies to numbers in the table visualization and when hovering over data points on a chart visualization, but not to the counter visualization or when formatting axis values. Here are examples for the various format options.
Numbers
Number
Format
Output
10000
'0,0.0000'
10,000.0000
10000.23
'0,0'
10,000
10000.23
'+0,0'
+10,000
-10000
'0,0.0'
-10,000.0
10000.1234
'0.000'
10000.123
100.1234
'00000'
00100
1000.1234
'000000,0'
001,000
10
'000.00'
010.00
10000.1234
'0[.]00000'
10000.12340
-10000
'(0,0.0000)'
(10,000.0000)
-0.23
'.00'
-.23
-0.23
'(.00)'
(.23)
0.23
'0.00000'
0.23000
0.23
'0.0[0000]'
0.23
1230974
'0.0a'
1.2m
1460
'0 a'
1 k
-104000
'0a'
-104k
1
'0o'
1st
100
'0o'
100th
Currency
The following examples use a $ symbol to denote currency. You can use any other currency symbol that is available on your keyboard.