# Ranking data

Learn how to create Top N rankings in dashboards to highlight best- and worst-performing metrics 

### Why ranking is essential for storytelling

{% hint style="success" %}

### Ranking spotlights top and bottom performers

* Ranking data derives the most important data points from large datasets.
* Top N ranking makes it easy to compare metrics across, say, regions or products.
* Brings top and bottom performers into focus across charts, KPI cards, and tables in your Fabric dashboards.
  {% endhint %}

#### Ranking spotlights top and bottom performers

* Ranking data derives the most important data points from large datasets.
* Top N ranking makes it easy to compare metrics across, say, regions or products.
* Brings top and bottom performers into focus across charts, KPI cards, and tables in your Fabric dashboards.

<figure><img src="https://images.gitbook.com/__img/dpr=2,width=760,onerror=redirect,format=auto,signature=1114240123/https%3A%2F%2Fcontent.gitbook.com%2Fcontent%2FgpZMtmCle9DxbUFj1eY8%2Fblobs%2FzVXBwhKjxawIHBl9y3Bm%2Fimage.png" alt=""><figcaption></figcaption></figure>

### Configure ranking in charts

1. Click the TopN option from the toolbar

<figure><img src="/files/eHHdbETs1IA3QrVtDyzg" alt=""><figcaption></figcaption></figure>

2. Display the top or bottom performing categories

   <figure><img src="/files/erd8dHeVzxyh8rO9tuco" alt="" width="264"><figcaption></figcaption></figure>
3. Rank by percentage or measure value and specify the number of items to show.

<figure><img src="/files/snTEivtSENKBt8poGXSv" alt="" width="264"><figcaption></figcaption></figure>

4. Choose to club the remaining items and display them as a single category.

<figure><img src="/files/Iv5qE6vlx0golb0p9rd8" alt="" width="265"><figcaption></figcaption></figure>

### Ranking axis categories in charts

Configure ranking from the **Axis** tab. All categories are plotted when **Display** is set to **Off**.

<figure><img src="/files/5dc2qJw6F1hibUUy7KDs" alt=""><figcaption></figcaption></figure>

Define the number of categories to display the highest or lowest contributors.

<figure><img src="/files/trhocoPgK1adEIxrKtfY" alt=""><figcaption></figcaption></figure>

### Row and column ranking

You can rank based on rows or columns for charts and tables in trellis mode. The Top N interface has a row and column tab for trellises. Follow the steps outlined in the setup section in each of these tabs.

Let's use TopN ranking to find the regions and product categories with the least sales.

<figure><img src="/files/SiohUGGB44KH8R4WNBLD" alt=""><figcaption></figcaption></figure>

The top or bottom performing categories are rendered.

<figure><img src="/files/vs4LCgej0nxpXjjTlL6t" alt=""><figcaption></figcaption></figure>

### Ranking for stacked charts

Apply Top N ranking to stacked charts to display only the top or bottom performing categories. The steps outlined in the setup section can be applied in the **Stacked** tab. The images show how ranking can be used to display the top-performing stacked categories.

Apply ranking from the **Stacked** tab.

<figure><img src="/files/4FsNrBmWWB9nP9C6LKbc" alt=""><figcaption></figcaption></figure>

Best performing segments are rendered:

<figure><img src="/files/h89EexGsQSHhtpYso3DF" alt=""><figcaption></figcaption></figure>


---

# 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.fabricplan.com/intelligence-sheets/how-tos/ranking-data.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.