Power Query (M)agic: Consecutive Days
Hello P3 Adaptive World! My name is Krissy Dyess and I have had the most amazing experience working as a full-time consultant at Power Pivot Pro since April 17, 2017!
Category: Skill Areas
Power BI Feature Spotlight: Bookmarks
Every month Power BI gets an update that adds a nice handful of new features. Let’s read about this month’s awesome feature…Bookmarks.
Dynamic Attributes In A Power BI Report
Dynamic attributes and how to implement them in Power BI Desktop or Power Pivot using “Harvester” measures and disconnected slicers.
SUMMARIZE() & ADDCOLUMNS() aren’t scary… if you can SEE them!
I tried solving this problem and the internet led me to SUMMARIZE(). It was stuffed inside another function and it confused me
DAX Reanimator: Moving Averages Controlled by Slicer (Part 2, including GFITW)
Today, I’ll show you how to bring the awesome to moving averages with DAX text formulas for slicers and titles… and yes, I’ll throw in a Greatest Formula In the World (GFITW) version, too.
DAX Reanimator Series: Top Performers using SUMMARIZE
Welcome back P3 Adaptive nation, today I’d like to demonstrate some exciting ways to show Top Performing “things” using DAX. Most of what we’ll discuss has been covered before in […]
DAX Reanimator Series: Moving Averages Controlled by Slicer (Part 1)
DAX Moving Averages measure controlled by slicer in Power BI, using what-if-parameters, GenerateSeries, and disconnected table.
AutoExist, Cross Table Filtering, and You
The autoexist logic magically removes combinations that don’t exist, but only for columns in the same table. Also, Cross Table Filtering…
Stick a Drop Pin in It: Visualize Data With Maps (DAX Reanimator Series: Part 2)
Greetings P3 Adaptive Nation! I’m here today to talk about maps, maps, globes, charts, topographical representations, and…well frankly I’m out of map synonyms. However there’s at least twice as many […]
My Top 5 Power BI Visual Design Practices: Transforming Good to GREAT
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
DAX “Reanimator” Series, Episode 1: Dynamic TopN Reports via Slicers
Dynamic TopN Reports via Slicers: Now you can click, slice, interact, touch (…dirty), and drill (dirtier!) with these reports to your hearts desire.
Mighty Morphing Pivot Tables or: How I learned to automatically change hierarchy levels on rows
First off…my first post! Being one of the newest (and youngest) members of the P3 Adaptive family has been very exciting so far. As a way of introducing myself, I’d like to share a creative solution to a problem I’m sure many of you have encountered when building a report or dashboard.