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
Get your March Madness brackets sorted with this Power BI report that analyzes all the game data results for the past 35 years of the current March Madness tournament format.
This is just a fun report I created in the weekend, and I'm not usually a March Madness fan so let me know what other info you want to see and I can update it, or better yet create your own version and tag me: @AllisonKennedy #ExcelwithAllison
eyJrIjoiOTE1NzljYWItYzQyNy00YmZkLTg1YTEtYjNlN2I2YmVlNmIyIiwidCI6IjBiOGU2NWNiLWRjMmUtNDQ0Yy1hOGUwLTE4MmYyYTdmODc1YyJ9&embedImagePlaceholder=true&pageName=ReportSection808d5759feb85351df17
Copying DAX from this post? Click here for a hack to quickly replace it with your own table names
Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C
I work as a Microsoft trainer and consultant, specialising in Power BI and Power Query.
www.excelwithallison.com
Allison,
I can really appreciate this as a Bball fan. Great looking dashboard! Is it possible to share the pbix and data source, I'd be interested to give this a shot since it can be used year after year. y.s@yourspacestr.com
Thanks a bunch.
@Cav Sorry for the delayed reply. The report is old so the original data sources I used may not exist anymore but here's a copy you can use:
March Madness Historical Report.pbix
Please just reference www.excelwithallison.com if you use any part of the report anywhere.
Thanks!
Copying DAX from this post? Click here for a hack to quickly replace it with your own table names
Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C
I work as a Microsoft trainer and consultant, specialising in Power BI and Power Query.
www.excelwithallison.com
Nice post, @AllisonKennedy
For anyone interested, please check out a solution I made for this year's March Madness tourney. It can be imported into any Teams channel to collect brackets from people in your own local competition. This playlist includes a walkthrough of the app, a link to download the solution, instructions for importing it, and soon a Power BI report to track the competition.
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
Thanks @mahoneypat for the inspiration. I'm always looking for new data to play with! 😊
Copying DAX from this post? Click here for a hack to quickly replace it with your own table names
Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C
I work as a Microsoft trainer and consultant, specialising in Power BI and Power Query.
www.excelwithallison.com