> For the complete documentation index, see [llms.txt](https://docs.inforiver.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.inforiver.com/super-filter/features/7.-sorting-and-ranking.md).

# 7. Sorting and Ranking

{% hint style="success" %}
**Applicable in:** ❌Date Filter **✔️**Facet Filter **✔️**Hierarchy Filter ❌Alpha Numeric Filter

❌Numeric Filter
{% endhint %}

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.

{% embed url="<https://www.youtube.com/watch?index=11&list=PLisLVA_RnBO5QEJvAbyNHwfdboQVbF7LC&t=50s&v=QTDGqxLq2V4>" %}
Video 1: Sorting/Ranking
{% endembed %}

## 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.

{% stepper %}
{% step %}
Add a **Facet** or **Hierarchy Filter** in the super filter visual.
{% endstep %}

{% step %}
**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.
  {% endstep %}

{% step %}
Under **Sort by**, choose either:

* **Alphabetical** – sorts values alphabetically.
* **Measure** – sorts values based on the measure added in the **Others** category.
  {% endstep %}

{% step %}
**Select Sort Order**:

* Under **Sort as**, choose **Ascending** or **Descending** to display values accordingly.
  {% endstep %}

{% step %}
**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**.
  {% endstep %}
  {% endstepper %}

<figure><img src="/files/UyZWRa6KSZcK2YdmHz5C" alt=""><figcaption><p>Image 1: Sorting option in User Interface of visual.</p></figcaption></figure>

<figure><img src="/files/zRYJloYIaw6FrdwvZ8Uc" alt="" width="284"><figcaption><p>Image 2: Sorting format pane settings.</p></figcaption></figure>

{% hint style="warning" %}
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.
{% endhint %}

## How to Use Ranking:

{% stepper %}
{% step %}
**Enable Ranking**:

* Use the toggle button in the Format Pane to enable **Ranking**.
* Note: Enabling Ranking will disable Sorting.
  {% endstep %}

{% step %}
**Set Top/Bottom N Type**:

* A dropdown is provided to choose between **Top N** and **Bottom N** rankings.
  {% endstep %}

{% step %}
**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.
  {% endstep %}

{% step %}
**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.
  {% endstep %}
  {% endstepper %}

{% hint style="info" %}
Example: Display the **Top 10 Products** by revenue in a Facet View to highlight the most profitable items.
{% endhint %}

<figure><img src="/files/gZjqfQVafmjILAoPITDx" alt="" width="543"><figcaption><p>Image 3: Ranking in User Interface of visual.</p></figcaption></figure>

<figure><img src="/files/TeruHUgR8IyLcDUjjxVc" alt="" width="284"><figcaption><p>Image 4: Ranking format pane settings.</p></figcaption></figure>


---

# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.

## Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter, and the optional `goal` query parameter:

```
GET https://docs.inforiver.com/super-filter/features/7.-sorting-and-ranking.md?ask=<question>&goal=<endgoal>
```

`ask` is the immediate question: it should be specific, self-contained, and written in natural language.
`goal` is optional and describes the broader end goal you are ultimately trying to accomplish on behalf of the user. GitBook uses it to tailor the answer towards what is most useful for that goal.

The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.