Format numeric types in visualizations
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 |