Microsoft EmployeeFantasy Football Draft Kit
Would love if you could forward this pbix to me as well. I have lots of fantasy football content I've been doing with PBI, but love the look of your example above.
- SeanDonovan
I've added the PBIX file to the description above. Hope it helps!
This is great! Thank you. Utilizing the underlying data, have you thought about creating a draft board using PBI? I created one years ago with Excel that uses lists, combo boxes, offsets etc to make the corresponding pick in a column/row populate a draft board in a snake order. Thinking that if this can be done in Power BI, it would be much more aesthetic and probably easier to use/update. Case in point I just opened my Excel file from a couple years ago to update it, and the combobox/VBA is no longer working...
jnpbHelper I
Hi Sean,
Downloaded the PBIX you added - what a great implementation!
One thing I'm struggling with is with adapting this to our league's scoring system. I can't seem to figure out how to add a Kick20Points (0-19 FGs in our league are 2 pts, 20-39 are 3). Any advice on how I could make this change?
Disclaimer: have only been using PBI for a very short while, so am stumbling my way through it.
Thank you in advance for any insight you might be able to offer!- SeanDonovan
A new "What-If" parameter (Kick20Points) will need to be added to the report first. Once that is created, the "Fantasy Points" measure will need to be modified to account for the additional scoring rule.
I was able to make the change and attach a modified PBIX file from the post above.
