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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
Black3y
Microsoft Employee
Microsoft Employee

Create ranked leaderbord and add movement week on week

Hi all, 

 

I am a total PowerBI novice and am trying to get my head around hwo to do some ranking and movement to create a leaderboard. I simply have 2 (and will soon have 6) tables with scores that players have accumalated each day and I want to combine them and include up/down/static graphics to show movements, much like the image below..

 

Rank.PNG

 
 

scores.png

 

I've started playing around in the Power Query editor but this is a steep learning curve for me, so please excuse my noobiness! 🙂

5 REPLIES 5
MFelix
Super User
Super User

Hi @Black3y ,

 

Can you share a sample data file?

 

Please see this post regarding How to Get Your Question Answered Quickly:

https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490 (courtesy of @Greg_Deckler).


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



Black3y
Microsoft Employee
Microsoft Employee

Day 1 could look like this...

Rank

PlayerScore
1

Player1

20
2Player218
3Player316
4Player414
5Player512

 

Then Day 2

RankPlayerScore
1

Player1

20
2Player218
3Player316
4Player414
5Player512

 

So I want to add the scores and then rank accordingly... if that makes sense?

Black3y
Microsoft Employee
Microsoft Employee

Update... I have managed to create rank so now I just need to know how to create the graphics when the rank changes from day to day. Any help much appreciated. I'm able to modify the source excel document to calculate the sum of scores from each week on week if its easier to do that way, whatever 🙂

 

 

 

Untitled.png

Black3y
Microsoft Employee
Microsoft Employee

Hi anyone who is still listening... So as below, I have now created a new ranking for a new table that comines the scores from day 1 and day2. As uo can see, there have been some movements in the scoreboard that I would like to indicate with some nice up/down green/red symbols.

 

Anyone...?

 

Untitled2.png

 

 

Hi, can you please share how you achieved this

 

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!