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 your home page, hover over a workbook, click Actions, and select Open.
  2. Select a visualization.
  3. Click Properties, then click Values Values Properties tab.
  4. Expand the measure that you want to format.
  5. Under Number Formats, in the row for the output you want to configure, click Abbreviate.
  6. 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.
  7. Click Save.