Introduction
In Day 19, you learned how to calculate Percentage of Total to understand contribution.
That helped you identify which products or regions contribute the most.
But businesses often want something more direct.
They ask:
Who are the Top 5 performers?
Which products are performing the worst?
Instead of manually filtering every time, Power BI allows you to rank data dynamically.
In Day 20, you will learn how to use ranking functions to automatically identify top and bottom performers.
What You Will Learn Today
You will create ranking measures using DAX
You will identify Top and Bottom performers dynamically
You will use ranking inside visuals
You will build dashboards that automatically adjust rankings based on filters
Why This Skill Matters for Your Career
Managers don’t review entire datasets.
They focus on:
Top-performing products
Best regions
Lowest-performing categories
Ranking helps answer these questions instantly.
It is widely used in sales dashboards, performance reports, and business reviews.
Knowing this shows you can prioritize insights, not just display them.
Understanding Ranking in Simple Terms
Think of exam results.
Students are ranked based on marks:
Highest marks → Rank 1
Second highest → Rank 2
Ranking in Power BI works the same way — but dynamically based on filters and selections.
How This Connects to Previous Days
You already calculated:
Total Sales
Growth
Contribution %
Now you will rank these results to identify leaders and laggards clearly.
This makes decision-making faster.
Step-by-Step: Create a Rank Measure
Go to Modeling → New Measure.
Write the following formula:
Sales Rank =
RANKX(
ALL(Sales_Data[Product]),
[Total Sales],
,
DESC
)
Press Enter.
This ranks products based on Total Sales, with highest sales getting Rank 1.
What This Formula Is Doing
RANKX compares each product’s sales with all other products.
ALL() removes filters so ranking is done across the full dataset.
DESC ensures highest values get top ranks.
Step-by-Step: Use Ranking in a Visual
Create a Table visual with:
Product
Total Sales
Sales Rank
Now your table shows clear ranking.
Sort by Rank to see top performers first.
Identify Top Performers
Apply a filter:
Sales Rank ≤ 5
Now your visual shows Top 5 products dynamically.
When filters change (Region, Date), ranking updates automatically.
Identify Bottom Performers
Change ranking order:
Use ASC instead of DESC
Or filter:
Sales Rank ≥ (last ranks)
Now you can identify lowest-performing items.
Common Beginner Mistakes to Avoid
Do not forget to use ALL() — otherwise ranking will break with filters.
Always define ASC or DESC correctly.
Avoid using ranking without a proper measure like Total Sales.
Try This Yourself
Create a bar chart:
Axis → Product
Values → Total Sales
Then add a filter for Top 5 using Rank.
Observe how the chart dynamically updates when slicers are used.
How Today Builds on Previous Days
Day 18 → Running totals
Day 19 → Contribution analysis
Today in Day 20, you ranked performance.
Now your dashboard can:
Show trends
Measure growth
Track contribution
Highlight top performers
This is how real dashboards support decision-making.
What Comes Next
Next, you will learn how to combine multiple insights into a dashboard layout with KPIs and summary visuals, making your report presentation-ready.
Stay Connected and Keep Practicing
Blogs WhatsApp Channel (for daily quizzes and blog updates):
https://whatsapp.com/channel/0029VbCcWME4inotCWmN5511
Telegram Channel (Job Updates & Career Alerts):
https://t.me/careervalore
WhatsApp Channel (Daily Job Updates):
https://www.whatsapp.com/channel/0029Vay7sUV11ulUIhLBUI44
Conclusion
Today you learned how to rank data dynamically in Power BI.
By identifying top and bottom performers, your dashboard now highlights the most important insights instantly — helping users focus on what truly matters.
Leave a Reply