Power BI and fantasy league data

Back to playing with Power BI. I’m using the data from my Fantasy league team and seeing what insights I can get.┬áThis is the first post of many on this subject. Future posts will have more details in them.


The idea is to see the data from a details and KPI perspective.

KPIs are based on what I would my team to score, so Captain points are 15, other players just below 5. I came up with these numbers based on.

  • Team needs to get 60 points
  • Captain needs 15 points
  • 45 points shared between the other 10 players.

In the first set of charts the waterfall chart has drill down capabilities.

Top level, which shows points by week.

First level down shows points by players

Bottom level shows points by bench and first 11. ‘Y’ is bench.


I’m hoping this data will help me get higher in the leagues.