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 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.
Number |
Format |
Output |
---|---|---|
1000.234 |
‘$0,000.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 |