Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
08-03-2018 03:38 AM
Fantasy Football Player Comparison Tool
With the new NFL season just around the corner its time to prepare for your fantasy draft!
Use the fantasy football player comparison tool by selecting player 1 & player 2 from this lists provided. The report allows you to compare players by viewing key stats including total fantasy points for the previous season, projected receptions, yards and touchdowns for the upcoming season as well as this seasons NFL.com 2017/18 predicted points total.
What IFs have been included to allow the user to create their own player projections under the sections 'Calculate Your Own Projection'. Simply adjust the selected player/s yards and touchdown amounts to see how it will affect their overall fantasy points. The scoring is based on the standard NFL.com fantasy scoring system.
An option has also been included for PPR (points per reception) leagues, if your league is a PPR league then select 'Yes' in the top left corner and the overall points calculation will then also take into account the added points for each of the players receptions.
The data used is courtesy of - http://fantasy.nfl.com/research/projections, http://www.nfl.com/stats/player
eyJrIjoiMmEzOGFiNmYtZTRlMC00NWEyLTk2M2YtM2VlZmVmODhiZjI2IiwidCI6ImZkMGFhMzU2LWE0NTMtNDYzNS05NGI3LTdhOTRjMjcyNWNiOCIsImMiOjh9
David Lanagan, I hope you are well.
Congratulations on the Dashboard. I'm looking for something similar. My scenario is for measuring the performance of each sales team. I'm new to the language, so I'm having trouble finding this type of content.
Could you share the pbix file on email: andresvezzia2@gmail.com
Thank you very much!
I found it in the comments.
Thank you!!
Can you please share the pbix file :r151703@rguktrkv.ac.in
Could you please share .pbix to my mail adress? marcelo_cpv@hotmail.com
Thank you !
could you please share the pbix to me so that I can learn the logic behind. my mail box diegoaleman344@gmail.com thanks good day
please share me the pbix file soumyasajith403@yahoo.com
David,
Sweet tool, Might to be able to acutally win a few games with this 🙂
Would you mind sending the pbix file to me at drew.d@outlook.com
Thanks in advance
hello, david
that is awesome!
i am really spent many times look like that report
please tell me send me the pbix file if you that`s okay
This is really cool - awesome use of PowerBI. I'm looking to create a similar one for the Australian Rules Football - are you able to send me a link to the .pbix file? It would provide an excellent template!
Thanks for sharing!
I really love the report. Amazing work. Would you be wiling to share the file so that I can try to understand the steps and the logic behind things.
Thank you
Hi,
The PBIX file is already uploaded, it is up earlier in the chat.
Thanks!
Do you have some kind of document or steps which I can go through in order to understand how exactly you made sucha wonderful report?
This is really cool David!
I was wondering if you could possibly share your .pbix file as I would really like to know how this is done.
Thanks in advance.
Hi - Thanks for the comment, the PBIX is further up in the chat.
All the best,
David
Hello David, Would you be able to share how you had the slicer for the players name bring up the corresponding picture for that player?
Thank you
Hi Drew248
In order to get the player pictures to work in that way I downloaded the pictures and saved locally. I then used a website to create an image url for each picture, the image url can then be added into a column within the table/dataset for each player.
In Power BI I think I used the table visual which lets you drag in the image url field as a value, I then added the chiclet slicer and filtered on the player name field from my dataset. I set the chiclet slicer properties to force the need for there always to be a player name selected and also only allow one option/player could be selected at a time.
I have attached an image that may be of use.
All the best,
David
are you going to build one for the upcoming fantasy season ?
Hi Drew,
I haven't planned on making another comparison tool exactly like this, but I have been developing a new report based around NFL QBs past and present but I just havent had enough time to finish it off. Once I do finish it I will try to upload it.
Did my explanation help from the other week btw? Your question about the player images and filters...
David
Hi David,
Can you add a relevant description file as to how the report is prepared?
Thank you.