Formatting measure values in a chart

  1. Click a measure in Chart Builder. The options menu opens with a section for each measure.
  2. Click Data Formatting for the column you want to change. Visualizer displays the options with the defaults highlighted.
  3. Select the unit for formatting numbers. When you select an option, Visualizer immediately updates the chart axis and the tooltips. Options include:
    • Auto default - commas (150,413,715)
    • None - no commas (150413715)
    • K - divide by 1,000 (150,413.71K)
    • M - divide by 1,000,000 (150.41M)
    • B - divide by 1,000,000,000 (0.15B)
    • % - multiply by 100 (15,041,371,500%).
  4. Select the suffix, for display purposes only.
  5. Select the decimal precision.
  6. Select the currency symbol. This is for display only, it does not change the data.
  7. Click Save.
Note: 
  • Visualizer supports dynamic currency symbols. You can define a variable and use it as the currency format by entering the GetVariable('variable_name') syntax. See Using Variables.
  • Dynamic currency symbols using GetVariable is not supported in the Pro version.
  • If you have merged more than one measure on the axis and the currency symbol is not the same for each measure, Visualizer does not display a currency symbol on the axis. To display a currency symbol on a merged axis, set both measures to use the same currency. For example, set Revenue and Forecast Revenue to both use Euros.

  • You can override formatting at the data level with formatting at the chart level.