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.

Sorting in widgets with two dimensions

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

Sorting Limitations

When configuring sorting, consider the following limitations:

• Sorting applied to dimensions not involved in data display within the widget will cause an error. For example, this may occur if:
  • A second dimension is added to a widget that displays data only for the first (top-level) dimension, and sorting is applied to the second dimension
  • The order of dimensions is changed while a custom sort is applied to the first dimension’s column
• By default, Pivot Table applies automatic sorting across all columns. If a display condition is assigned to a dimension, automatic sorting is disabled. In this case, to restore default behavior, manually add sorting by component for all rows and columns of the Pivot Table