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.


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
Bar charts (all Horizontal) Y axis and Value
Bar charts (all Vertical) X axis and Value
Combo charts (all) X axis, Bars, and Lines
Geospatial charts Sorting not supported
Heat map Columns and Values
KPIs Sorting not supported
Line charts (all) X axis and Value for numeric measures only
Pie chart Value and Group/Color
Pivot table Column
Scatter plot Sorting not supported
Tabular Reports Group by and Value
Tree map Size, Group by, and Color

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: