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

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

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
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

December 2025 Power BI Update Carousel

Power BI Monthly Update - December 2025

Check out the December 2025 Power BI Holiday Recap!

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.