Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
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..
I've started playing around in the Power Query editor but this is a steep learning curve for me, so please excuse my noobiness! 🙂
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
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsDay 1 could look like this...
Rank | Player | Score |
1 | Player1 | 20 |
2 | Player2 | 18 |
3 | Player3 | 16 |
4 | Player4 | 14 |
5 | Player5 | 12 |
Then Day 2
Rank | Player | Score |
1 | Player1 | 20 |
2 | Player2 | 18 |
3 | Player3 | 16 |
4 | Player4 | 14 |
5 | Player5 | 12 |
So I want to add the scores and then rank accordingly... if that makes sense?
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 🙂
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...?
Hi, can you please share how you achieved this
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
115 | |
112 | |
105 | |
95 | |
58 |
User | Count |
---|---|
174 | |
147 | |
136 | |
102 | |
82 |