Ranking data

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

Why ranking is essential for storytelling#

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.

Configure ranking in charts#

1. Click the TopN option from the toolbar

2. Display the top or bottom performing categories

   

3. Rank by percentage or measure value and specify the number of items to show.

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

Ranking axis categories in charts#

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

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

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.

The top or bottom performing categories are rendered.

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.

Best performing segments are rendered: