Setting the data format in a view

You can set the data format on a row or column, or on the entire view.

Data formatting can be done in the view (exploration) or visualization. The formats are retained when the view is switched back to exploration or other type of visualization.

Procedure

  1. Do the following steps to set format on a row or column in the exploration or visualization:
    1. Right-click the column or row header, and click Format values. If you are using the new experience view, click Formats instead.
      For visualizations, you can access the Format values menu from the data item context menu Context menu icon under the Fields tab.
    2. Select the format, such as Currency.
      You can apply formatting to both columns and rows. Column formatting takes precedence over row formatting. For visualizations, you can also set the data format for the axes.
    3. If none of the built-in formats are suitable, select Custom format and type the pattern for the custom format.
    4. To reset the format that is used to the database default, select Use database format.
  2. To set format on the entire view:
    1. Click the handle, then click the Format values icon Format value icon in the application toolbar.
    2. Select the format, such as Currency.
    3. If none of the built-in formats are suitable, select Custom format, and type the pattern for the custom format.
    4. To reset the format that is used to the database default, select Use database format.