Menu
Amazon QuickSight
User Guide

Sorting Visual Data in Amazon QuickSight

Most visual types offer the ability to change data sort order. Whether sorting is supported and what visual element you can sort by depends on the visual type.

Important

Sorting by text fields (those with a string data type) isn't supported for visuals based on SPICE data sets.

Use the following table to identify the field wells/on-visual editors that support sorting for each visual type.

Visual type Field well or on-visual editor
Horizontal bar charts (all) Y axis and Value
Vertical bar charts (all) X axis and Value
Combo charts (all) X axis, Bars, and Lines
Line charts (all) X axis and Value
Pivot table Column
Scatter plot Sorting not supported
Tree map Size, Group by, and Color
Pie graph Value and Group/Color
Heat map Columns and Values

Sorting a Visual

For most visual types, you can use either a field well or an on-visual editor to choose the sort order. Pivot tables behave differently; you specify the sort order by using the column sort icon on the visual. For more information about sorting pivot tables, see Sorting Pivot Tables.

Use the procedures below to sort any non-pivot table visual type by using either a field well or an on-visual editor.

Sorting by Using an On-Visual Editor

  1. On the visual, choose an on-visual editor that supports sorting.

  2. On the on-visual editor menu, choose Sort, and then choose the ascending or descending sort order icon.

Sorting by Using a Field Well

  1. Expand the Field wells pane by choosing the expand icon.

  2. Choose a field well that supports sorting.

  3. On the field well menu, choose Sort, and then choose the ascending or descending sort order icon.

On this page: