Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

League Ranking Position over time

I have a Power BI report for our work Fantasy Football (Soccer, not Gridiron) league. I have various representations of the data including a league table and analysis of performance by site and...
  • PaulDBrown's avatar
    4 years ago

    Assuming the data depicted is the actually weekly rank by team, first you will need to unpivot the columns for week and rank.

    You can then set up your visuals with whatever preference you have. Here are a couple of options, albeit with some weaknesses.

    A stepped line chart with an inverted Y axis to show rank 1 the highest (which is what you would expect for a rank)

    The problem is that if there is too much data it looks pretty messy

    But it can work to compare a couple of teams:

    If you want to show a larger number of teams, maybe the same line chart but shown either in a non-stepped format

     


    or shown as small multiples. Add conditional formatting to highlight each week's number 1 and you get:

     

    I've attached the sample PBIX file

     

    Edit: Just thought I'd showcase another option which has some dynamism. You can use a scatter chart with a play axis for the weeks to get this: