7. Sorting and Ranking

Applicable in: ❌Date Filter ✔️Facet Filter ✔️Hierarchy Filter ❌Alpha Numeric Filter

❌Numeric Filter

The Sorting and Ranking options in the Format Pane allow you to organize and prioritize the data displayed in the visual for better clarity and focus.

How to Use Sorting

Sorting is available for all types of views, enabling you to define the order in which items appear in the visual.

1. Access the Sorting Option:

Navigate to the Sort option in the Format Pane.

2. Select Sorting Criteria:

A dropdown list is provided under sort by, showing all data fields added under Category and Others.
Fields added to Category are displayed as "Category" in the dropdown.
Fields added to Others are displayed by their names.

3. Choose Sorting Order:

After selecting a field, a new option, Sort As, becomes available.
Use the dropdown to select either Ascending or Descending order.
When a data field from the "Others" section is selected for sorting, sorting option becomes available in the visual's user interface.
The data in the visual is sorted based on your selection.
Example: Sort sales data by categories in ascending order to group items alphabetically.

4. Absolute Sort:

The Absolute Sort option allows users to sort items based on their absolute values when enabled.
This ensures that the sorting is done purely based on the absolute value of the data, providing a clear and consistent order regardless of the original sign (positive or negative).
This option is available only when sorting criteria is selected as Measure or Numeric datatype.

Changes to Ranking and Sorting made directly in the UI will not be retained when switching pages or reopening the report. Only ranking and sorting configured in the Format Pane will persist.