P3: Mighty Morphing Pivot Tables or: How I learned to automatically change hierarchy levels on rows

The Pivot Table featured below acts as if we’ve swapped out fields on rows – in response to a slicer click! First off…my first post! Being one of the newest (and youngest) members of the PowerPivotPro family has been very exciting…

Posted on March 9, 2017 by Reid Havens and filed under Advanced, Excel, PowerPivotPro and tagged Tips & Tricks Pivot Table Intermediate DAX.

Blog Search

View The Archives

Subscribe to Access the Video Power BI Files!

Signup for our mailing list to gain access to Power BI files and templates from the videos. You’ll receive a welcome email with a link and password to the Blog Files page.

Blog Signup Form

Blog Files Page

Reid Havens’ early love affair with analytics has, over the past decade, turned into an evolution into data visualization and report design in Power BI.

Since then Reid has been writing articles and creating YouTube videos to share the word of BI, helping to inspire the next generation of Business Intelligence enthusiasts.