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.
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
Click the TopN option from the toolbar
Display the top or bottom performing categories
Rank by percentage or measure value and specify the number of items to show.
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.
