Forum Discussion
League Ranking Position over time
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:
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:
Paul - I am bowled over by the amount of time and effort you have put into answering my question, your suggestions look to be bang on the money and I am looking forward to implementing them. We have 65 teams in our league so I am going to include a couple of slicers to limit population by player, site, department.
Paul - I used your solution and it is close to what I am looking to achieve. When all teams are included the Line Chart shows for the weeks in sequential order, however if I select a single player it results in the week order being subverted as per this example, this resolves if I select more than one player, any ideas why it should be doing this?