Format a text field - Amazon QuickSight

Important: We've redesigned the Amazon QuickSight analysis workspace. You might encounter screenshots or procedural text that doesn't reflect the new look in the QuickSight console. We're in the process of updating screenshots and procedural text.

To find a feature or item, use the Quick search bar.

For more information on QuickSight's new look, see Introducing new analysis experience on Amazon QuickSight.

Format a text field

When you format a text field, you can choose how to display null values using the Field list pane, an on-visual editor, or a visual field well.

To choose how to display a text field's null values
  1. Choose one of the following options:

    • In the Field list pane, choose the selector icon to the right of the number field that you want to format.

    • On any visual that contains an on-visual editor associated with the percent field that you want to format, choose that on-visual editor. Expand the Field wells pane, and then choose the field well associated with the number field that you want to change.

  2. Choose Format, and then choose More Formatting Options.

    The Format data pane opens.

  3. Expand the Null values section and choose whether to display null values as null or as a custom value. Using null is the default.