# Sorting and Top N

The Innofalls Chart offer you the possibility to sort the elements in a chart. You can specify by which measure and/or dimension the chart should be sorted by. You can also sort by deviations to quickly identify elements with the largest impact.

<figure><img src="/files/z26OXSqNocAnUxrXs6as" alt=""><figcaption><p>Sort and Top N Settings</p></figcaption></figure>

You can activate sorting by either **clicking on a axis label**

<figure><img src="/files/Tzq3OP1bHSFwRcLOHIcu" alt="" width="480"><figcaption></figcaption></figure>

or by clicking the **Sort and Top N** <img src="/files/PtevyqEFduCIgkz94RrT" alt="" data-size="original">button in the [navigation menu](/interactivity/navigation/navigation-menu.md).

{% hint style="info" %}
When *Top/Bottom N* is active, you can also click the **Rest** label to open the settings dialog.
{% endhint %}

### Sorting

When more than one measure or additional deviation charts are available in the visual, you can choose by which measure to sort by.

When the *Stack / Columns* field contains a dimension, you can select which member to sort by.

#### Sort Options

<table data-header-hidden><thead><tr><th></th><th></th><th data-hidden></th></tr></thead><tbody><tr><td>None</td><td>No sorting; the sort order given by Power BI is applied</td><td></td></tr><tr><td>Up</td><td>Sorts the values with the <strong>lowest value first</strong> by the specified sort measure. If only one measure is present in the chart, that one is taken and no measure choices are available</td><td></td></tr><tr><td>Down</td><td>Sorts the values with the <strong>highest value first</strong> by the specified sort measure. If only one measure is present in the chart, that one is taken and no measure choices are available</td><td></td></tr></tbody></table>

### Top / Bottom N

You can apply this option, if you wish to limit the amount of elements shown in the chart. When this constraint is active, the N number of elements with the highest (top) or lowest (bottom) values are shown and all other elements are summarized in a *rest member*.

You can either specify a fixed number of elements to keep or you can choose one of the *Auto* settings to determine the number of elements to keep automatically. Auto is a good choice for responsive reports (e.g. mobile reports). The smaller the visual, the fewer elements are visible.

If the number of elements present is less than the constraint N, no *Rest* is generated.

{% hint style="info" %}
You can rename the *Rest* member in the property pane under *Sorting + Top N.*
{% endhint %}

#### Top / Bottom N Options

<table data-header-hidden><thead><tr><th></th><th></th><th data-hidden></th></tr></thead><tbody><tr><td>None</td><td>No Top / Bottom N is applied</td><td></td></tr><tr><td>Auto Top</td><td><p>Keep top elements.</p><p>The amount of elements is determined by the <strong>size</strong> of the visual.</p></td><td></td></tr><tr><td>Auto Bottom</td><td><p>Keep bottom elements.</p><p>The amount of elements is determined by the <strong>size</strong> of the visual.</p></td><td></td></tr><tr><td>Top</td><td>Keep top elements specified by N.</td><td></td></tr><tr><td>Bottom</td><td>Keep bottom elements specified by N.</td><td></td></tr></tbody></table>


---

# Agent Instructions: 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:

```
GET https://docs.innofalls.com/interactivity/sorting-and-top-n.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
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.