Happy New Year 2019 to our P3 readers! For the new year, I have a question for you: What do you think of when you hear the word “Flow”? For me, I immediately think of “Flo” from Progressive – someone…
It’s The Time Of Year For Family Hello P3 Nation. All of us here at PowerPivotPro want to wish you a Happy Holidays! We also want to let you know that we’re taking a break for a few weeks for…
I see a lot of Power BI users asking for the ability to set a default slicer selection in their reports. Although this isn’t natively supported as of yet, we can imitate this functionality with a little bit of DAX!…
I’ve written in the past about using the CUBE functions in Excel. The general pattern of the examples I’ve used was pretty consistent: Creating a set of members of some sort, like products or customers using the CUBESET function Extracting…
Here are 2 tips for visualizations in Power BI Dashboard. In Power BI service (PBIS) there are reports. But there are also dashboards. Dashboards are sites to pin key visuals. People can view but not interact with them. They can click…
Power BI comes stocked with a great set of visuals that keep getting better (more options to do multiples, please). Even when the default set isn't enough, there is also a great collection of additional visuals you can find in…
Year End CPE Rush Doesn’t Have to Suck(When You’re Learning DAX and M)Happy Thanksgiving everyone! Normally I use this holiday as an excuse to post something off-topic, but this year, I’m gonna stay ON topic and share something I’ve been…
Have you ever needed to get data out to an internal customer quickly to meet an urgent business need, in an easy to access, updateable format? Of course! There are lots of ways to do this, and I’ve tried various…
Navigating the sea of data One of the many things which amazes me about Power Pivot time after time is its ability to effortlessly convert raw data into crucial information as soon as it happens. For example, receivables not being paid…
It’s sometimes difficult to find things that Power BI can’t do. There always seems to be a solution no matter the task at hand. A little while ago I was wondering to myself if it was possible to embed a…