Havens Consulting
Video by: Reid Havens
Ever wish your Power BI matrix could respond intelligently to what’s visible in the row hierarchy? In this video, I’ll show you how to create a dynamic matrix where column values, like department, title, or other employee attributes appear or disappear based on what’s selected in your row-level hierarchy.
We’ll combine a few clever modeling tricks to keep your matrix clean, relevant, and user-driven. Tune in to learn more!
Video by: Reid Havens
Ever wanted your matrix or table in Power BI to sort by a hidden value — without showing that value in the visual? In this video, I’ll show you a powerful trick using zero-width Unicode characters to embed an invisible sort order directly into your categorical columns.
We’ll walk through a demo using a dataset of transaction IDs and regions, and show how you can control sort behavior without cluttering your visuals. Tune in to learn more!
Video by: Reid Havens
Learn how to create a chart that always displays the same number of calendar periods, driven by slicer period selection, and regardless of if there is existing data (yet) for a period. This leverages a [DAX] generated table, relationships, and some auto-magic features. Tune in to learn more!
Video by: Reid Havens
As a follow up to a my previous video on creating an enhanced vertical/horizontal waterfall chart. In this video I'm going to show you that it's "possible" to create a categorical waterfall chart, but with a few considerations and caveats. Tune in to learn more!
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.
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.
