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:
Anonymous
As a fellow Fantasy Footballer (American football though for me), let me present my solution.
First, I recommend putting your data into the following format. It will be much easier for PBI to work with your data.
| Team | Week | Points |
1 | 1 | 3 |
2 | 1 | 2 |
| 3 | 1 | 1 |
| 1 | 2 | 2 |
| 2 | 2 | 3 |
| 3 | 2 | 1 |
| 1 | 3 | 1 |
| 2 | 3 | 3 |
| 3 | 3 | 2 |
From there, you can create a "Bump Chart", I have included my example below. This is a great way to show rank. You can customize it to be fat lines with no circles, or use my example of fat circles at each week and skinny lines between. Totally up to you. Here is another good link to a website that discusses bump charts in PBI. https://www.syntelli.com/how-to-make-bump-charts-in-power-bi-tutorial
You need 2 easy functions for this visual with the data style I showed above:
A running total for the week, which you seem to already have.
Running Points Total =
VAR MaxWeek=
MAX('Table'[Week])
RETURN
CALCULATE(
[Sum of Points],
'Table'[Week] <= MaxWeek
)
And a RANKX to calculate the rank for each team. The visual will break it up by week for you.
Running Rank =
RANKX(
ALLSELECTED('Table'[Team]),
[Running Points Total]
)
Let me know if you need any further help and I hope this works for you and your fantasy league. Good luck to you!
-Caz