No Sort Date Tables!

No Picture

We've all been there. You go to create your visual with Months on the axis and you see April, August, December … and realize you forgot to create Sort By columns. One way around that is to use…

Read More »

Get Data From SharePoint Lists … But Fast

No Picture

SharePoint lists remain a convenient way to store data. However, get data from SharePoint lists with lots of items can be frustratingly slow. The updated SharePoint list connector improved things, but not completely. The video below walks through…

Read More »

March Madness With Dataverse For Teams

No Picture

A few years ago, I wrote a March Madness article on PowerPivotPro that used Excel as the data source (here). With the NCAA tournament being hosted in Indianapolis this year, I decided to revisit that post and make…

Read More »

Template Files are an Under-Sung Feature

Power BI allows individuals to build solutions that can increase productivity and generate new insights for entire organizations.  Usually that's done through publishing models/reports/dashboards to the Power BI service, which provides a secure, flexible, and powerful platform.  Another…

Read More »

Save time with a starter file

If you make lots of Power BI data models and aren't already doing it, a good practice is to make a starter file to use for new models instead of starting from scratch each time.  Although it is…

Read More »

It's All Relative – Normalizing the X Axis

I saw an article last month by someone at the Washington Post doing some analysis of Google Trends data for "All I Want for Christmas is You" (AIWFCIY) by Mariah Carey (link).  In it, he showed a year-on-year…

Read More »

Paginated Reports with Power BI Desktop

Welcome to the inaugural post for HoosierBI.com! I get to use Power BI some as part of my day job as a chemist, but I have been also been volunteering with non-profits, schools, etc. to help them with…

Read More »