Use custom compact numeric format to display values

You can now append one or more commas to the end of a custom number format pattern to display values in compact format in explorations and visualizations. Each comma present at the end of a format pattern scales the value display by 1,000.

A single comma results in the value being displayed as thousands. Two commas display the value as millions. Three commas display the value as billions.

For example, the format pattern #,##0.0, results in the value 1234567.89 being displayed as 1,234.6. The format pattern #,##0.0,, displays the same value as 1.2.

To improve the usability of compact format, you can include literals in the format pattern to display specified characters. You can use these characters to indicate that the value is displayed as thousands, millions, or billions. Literals must be enclosed in single quotation marks.

To improve upon the previous example, use the format pattern #,##0.0,'K' to display the value 1234567.89 as 1,234.6K. The format pattern #,##0.0,,'M' displays the same value as 1.2M.

For more information on setting custom formats, see Setting the data format in a view.