Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

Reply
tyan
Helper II
Helper II

TOP 5 and Button 5

This is the raw table. 

Store NameSeasonRating
A2021SS10%
B2021SS10%
C2022SS5%
D2022FW5%
E2022FW5%
F2022SS19%
G2023FY2%
H2023FY9%
I2022SS80%
J2022SS80%
K2023FY9%
L2022SS-15%
M2022SS-50%
N2023FY-86%

 

I would like to create a table or graphic like the movie rating. 

tyan_0-1646910092874.png

 

I know how to disply Top 5 using the TOP N and BUTTON N.  but what if a store got the same rating. for example. Store A and Store B got 10% in the same season. They should be on the first as well. I only would like to show top 5 stores and displays icon on the left side.  What dax function should i use for this situation?  
Thank you for helping me!

1 REPLY 1
MFelix
Super User
Super User

Hi @tyan ,

 

On your dataset the top 5 includes the store A and B if you use the TOPN on the filter the repeated values all appear, I have made some changes and added a Z store with 15% so has you can see altough I have Top5 it shows me 6 because there are two stores with 10%

 

MFelix_0-1646915411852.png

 

 

In this case your issue is that you don't want to present both stores?

 

You can also make a raking measure but has you can see stores with equal values get equal rankings:

MFelix_1-1646915698133.png

 


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



Helpful resources

Announcements
November Power BI Update Carousel

Power BI Monthly Update - November 2025

Check out the November 2025 Power BI update to learn about new features.

Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors
Top Kudoed Authors