Set Scale Options for Numbers and Currency Values

You can select an abbreviated preset scale option for a visualization column to display numbers or currency for thousands (K), millions (M), billions (B), or trillions (T).

You can change a column number scale format such as 32,810.00, to display in an abbreviated preset number scale format such as 32.81K. For example, select K to change a Sales column from displaying a value such as $37,723.21 to display the same value as $37.72K.

1. On the Home page, hover over a workbook, click Actions, then select Open.
2. Click Visualize and select a visualization.
3. In the properties pane for the selected visualization, select the Values tab and expand a measure column.
4. Under Number Format, click Abbreviate.
5. Select a value.
   • Select On if you want to automatically scale and abbreviate numbers.
   • Select a value if you want to choose a specific scale and abbreviation value.
   • Select Off if you want to disable abbreviations.
6. Click Save.