Forum Discussion
League Ranking Position over time
- 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:
Hi Anonymous
Clustered Column chart is good