2019 Called. It Wants Your Name in Lights (Guest Post Opps)
“Can I tell you a secret? You might be a song blogwriter.” How long has it been since I’ve thrown out a movie quote? Years, maybe? It might have been that long. And I must say, I had no…
Finding the Flow: A Beginner’s Guide to Microsoft Flow
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…
Happy Holidays!
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…
Setting a Default Slicer Selection
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!…
Cube Functions, the good the bad and how to make them great
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…
2 Tips for Visualizations in Power BI Dashboard
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…
Hijacking the R Visual
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…
Attention Accountants: Year-End CPE Options that Don’t Suck!
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…
A different use for Power BI: Self-service refreshes and extracts to Excel while managing security in Power BI
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…
Reducing DSO using Power Pivot
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…