2025 Week 34 | Build a Dynamic TopN report

When building reports, one of the most common requests I hear from users is: “Can I see the top three, top five, or top ten items without having to look at multiple visuals?”

The good news: yes, you can! And it’s cleaner than ever with numeric range parameters in Power BI.

In this week’s challenge we’ll build a report that lets your users interactively choose the number of top-performing products they want to see, without duplicating visuals or cluttering your report.

We’ll start with a simple dataset containing three columns: Product, Category, and Sales.

The goal is to build a bar chart that shows top-performing products, with all products listed on the y-axis and their total sales on the x-axis.

Instead of locking the chart to a fixed number of products, we’ll add a slicer so users can choose whether they want to see the top 3, top 5, or top 10. With one click, the slicer automatically highlights the Top N selection in blue.

To make the report even clearer, we’ll add a dynamic subtitle beneath the title. This text updates based on the slicer selection. Finally, we’ll enrich the chart with tooltips that appear when hovering over a product. These will display: Product rank, Product category, and Total purchases (how many units were sold).

This combination of dynamic highlighting, subtitles, and tooltips creates a clean, interactive report that communicates not just what the top products are, but also why they matter.