Format numeric types

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 the 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

Number Format Output
1000.234 ‘$0,0.00’ $1,000.23
1000.2 ‘0,0[.]00 $’ 1,000.20 $
1001 ‘$ 0,0[.]00’ $ 1,001
-1000.234 ‘($0,0)’ ($1,000)
-1000.234 ‘$0.00’ -$1000.23
1230974 ‘($ 0.00 a)’ $ 1.23 m

Bytes

Number Format Output
100 ‘0b’ 100B
1024 ‘0b’ 1KB
2048 ‘0 ib’ 2 KiB
3072 ‘0.0 b’ 3.1 KB
7884486213 ‘0.00b’ 7.88GB
3467479682787 ‘0.000 ib’ 3.154 TiB

Percentages

Number Format Output
100 ‘0%’ 100%
97.4878234 ‘0.000%’ 97.488%
-4.3 ‘0 %’ -4 %
65.43 ‘(0.000 %)’ 65.430 %

Exponentials

Number Format Output
1123456789 ‘0,0e+0’ 1e+9
12398734.202 ‘0.00e+0’ 1.24e+7
0.000123987 ‘0.000e+0’ 1.240e-4