TOPN function in Power BI - Dashboard Guide

Dashboard Mode - TOPN function

Dashboard Goal

Find the top 3 products by total sales to focus on best sellers.

Sample Data

Product	Category	Sales
Notebook	Stationery	150
Pen	Stationery	300
Desk Lamp	Electronics	200
Chair	Furniture	400
Monitor	Electronics	350
Stapler	Stationery	100
Table	Furniture	250

Dashboard Components

KPI Card: Total Sales

Formula: Total Sales = SUM(SalesData[Sales])

Result: 1750

Table: Top 3 Products by Sales

Formula:
Top3Products = TOPN(3, SalesData, SalesData[Sales], DESC)

Shows products with highest sales:

• Chair - 400
• Monitor - 350
• Pen - 300

Bar Chart: Sales by Product (Top 3 Highlighted)

Shows all products with bars sized by sales. Top 3 products are highlighted in a different color.

Dashboard Layout

+----------------------+----------------------+
|      Total Sales      |   Top 3 Products      |
|       (KPI Card)      |      (Table)          |
+----------------------+----------------------+
|              Sales by Product (Bar Chart)          |
+---------------------------------------------------+

Interactivity

A slicer for Category lets you filter the data. When you select a category, the Total Sales, Top 3 Products table, and Bar Chart update to show only products in that category.

Self Check

If you add a filter selecting Category = Electronics, which products appear in the Top 3 Products table?

Answer: Monitor (350), Desk Lamp (200)

Key Result

Dashboard shows total sales and highlights the top 3 products by sales with interactive category filtering.