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 Hierarchy and Facet Filter, enabling you to define the order in which items appear in the visual.
Add a Facet or Hierarchy Filter in the super filter visual.
Enable Sorting and Ranking:
Navigate to the Format Pane.
Enable the Sorting and Ranking section.
Sorting is shown by default. To sort by measure, add numeric data or DAX measure to others field.
Under Sort by, choose either:
Alphabetical – sorts values alphabetically.
Measure – sorts values based on the measure added in the Others category.
Select Sort Order:
Under Sort as, choose Ascending or Descending to display values accordingly.
Absolute Sort:
Enable Absolute Sort to sort items based on their absolute values, ignoring whether they are positive or negative.
Absolute Sort is available only when the sorting criteria is a 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.
How to Use Ranking:
Enable Ranking:
Use the toggle button in the Format Pane to enable Ranking.
Note: Enabling Ranking will disable Sorting.
Set Top/Bottom N Type:
A dropdown is provided to choose between Top N and Bottom N rankings.
Specify N Value:
Use the input box with up and down arrows to define the number of items to rank.
Example: Top 10, Bottom 5.
Select Top N Measure:
A dropdown list displays the measures added to the Others field.
Choose a measure to rank items based on its value.
