Sorting

By default, sorting is not displayed in widget settings. To add custom sorting, click the + Sorting button.

You can configure sorting by:

• A widget indicator
• Global workspace measures
• Global dashboard measures
• Columns from tables added to the Data Model

Sorting can be set in ascending or descending order.

By default, widgets are sorted as follows:

• Widgets are sorted by dimension values
• If a widget is based on a dimension with the Date, DateTime, or DateTime64 data type, sorting is ascending
• If a widget is based on a dimension with the String data type, sorting is alphabetical

This behavior applies to all widgets except the Donut chart (sorted by measure), Numerical indicator, and Parameter.

When widgets are built using two dimensions, the following rules apply to sorting.

For Pivot tables and Bar charts:

• Sorting is applied by the first dimension by default
• Swapping the dimensions changes the default sort order
• The default dimension is fixed and cannot be overridden by additional sorting rules

For Line graphs:

• Default sorting is applied by the first dimension
• Swapping the dimensions changes the default sort order