I read this blog (and Matt Allington, and Ken Puls) pretty religiously. But PowerPivotPro is probably my favorite because it deals with a lot of real-world situations, not just technical solutions. So, I’m going to continue that theme and…
The journey continues… Five years on from my life-changing encounter with PowerPivot, my pilgrimage to the Nirvana of Modern Excel continues with some occasional detours. When I first encountered PowerPivot back in 2013, I thought that this tool would obviously…
Adding Visual Flair In Power BI With Background Colors Hello P3 Nation! Today’s “post” is going to be a video link. Sometimes there are certain subjects, concepts, or post ideas that just don’t translate well to the written word, and…
Conditional Formatting Using Text In Power BI Desktop Hello P3 Nation! Today’s “post” is actually going to be a video link. Sometimes there are certain subjects, concepts, or post ideas that just don’t translate well to the written word, and…
How to Create A Real Time Dataset on Power BI.com Hello P3 Nation! Today’s “post” is actually going to be a video link. Sometimes there are certain subjects, concepts, or post ideas that just don’t translate well to the written…
It's time again for the March Madness tournament and another excellent opportunity to introduce/teach people at your company/organization about Power BI. This article explains one approach for doing March Madness Power BI style, and using everyone's bracket data to teach…
Surfs Up A long time ago a peer in Financial Planning and Analysis said "Financial Planning starts in the home.” I modified the statement to “Data analytics starts in the home.” This means that I have a host of personal…
Every month Power BI gets an update that adds a nice handful of new features. Here at P3 we ALL get excited for this! We often stand around the water cooler talking about all the new features. When a REALLY…
Slicers are Empowering! There have been several blogs and articles written on dynamic measures and how to implement them in Power BI Desktop or Power Pivot using “Harvester” measures and disconnected slicers. See here & here. These techniques are popular…
Do YOU Want To Be A Report Superstar? Hello again P3 nation, today I’d like to drop some reporting knowledge. I’m going to share some of my best practices for Power BI Reporting I’ve developed over the years. As many…