Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Creating a custom leaderboard

Hi there, is there a way to create a custom leaderboard that can pull data from multiple forms and be built into a simliar format such as this? With the ability to have an avatar/photo, player name, rank, and cumulative score. The score would be based on predetermined rules. Ideally, we would be able to pull from different forms and fields within forms to calculate scores. 

 

 

Need Help
Show and Tell
  • Anonymous's avatar
    Anonymous
    3 years ago

    Simple answer is yes, you can use images in tables, you can use the RANKX function to create the leaderboard ranking and the formatting options to make the table look how you want. 

     

    Hope this helps, accept as solution if so. 

    Thanks

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Simple answer is yes, you can use images in tables, you can use the RANKX function to create the leaderboard ranking and the formatting options to make the table look how you want. 

     

    Hope this helps, accept as solution if so. 

    Thanks

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      Thank you! Can individual users set their own images? For example, can the leaderboard be created in a way to pull a "player profile" that contains the player name and "avatar" or photo they set?

      • Anonymous's avatar
        Anonymous
        Not applicable
        3 years ago

        They would have to set their images in a database so that the table you get the image from in PBI can update and grab the new photos 🙂 There are a lot of helpful videos on youtube that talk about images in power BI and how to store them, i'd recommend having a look. 

        It's a little confusing but i'd say it's defnitely not too bad and you'd be able to do it as a new user with a bit of effort! If you have any more questions just PM them to me or write them here. If you could accept one of my posts as a solution I'd be more than appreciative 🙂 thanks so much and good luck!