Formatting numbers and dates

You can choose a display format for number and date columns.

For example, numbers can be displayed as percentages or in scientific notation, and negative numbers can be displayed in parentheses. You can also add a custom symbol or character string as a prefix or suffix to the displayed values.

  1. Open the display format dialog from the Measures and Dimensions panel or from the Data pane in the Prepare room:
    • On the Measures and Dimensions panel, select the Options gear icon beside a measure or dimension, and select Display Formatting.
    • In the Data pane in the Prepare room, select the Options gear icon in the header of a number or date column, and select Display Formatting.
  2. Select formatting options and select OK.
    If you're adding a character string prefix or suffix, the maximum number of characters is 256.