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