Change the format of data in a visualization

You can set the format of data in a visualization, overriding any existing formatting on an axis. A number of built-in formats are available, or you can specify a custom format.

When you set the format on an axis in a visualization, the axis retains the format when you change the member on the axis or when synchronization automatically changes the member.
Note: When you set the format on an axis in a visualization, the raw data format is not changed. You can reset the format by selecting Use database format.

The formats are also retained when you switch from one visualization to another or convert the visualization to an exploration and vice versa.

To apply formatting to a visualization axis:
  1. Select the visualization and click Fields.
  2. Click the menu icon for the axis that you want to format and select Format values.
    Axis menu showing Format values
  3. Choose the format that you want to apply to the axis.

You can also right-click the axis title in a visualization and click Format values to select and apply a format to the axis.