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!
🔥 Join us for a special livestream showcasing the Top 3 finalists from the Power BI DataViz Championship — including Jon Sandmann, the first-ever global champion!
🎨 See the best of Power BI data storytelling as these top-tier report designers walk you through the visualizations that wowed the judges.
👀 In this session, you’ll:
Get behind-the-scenes insights into their design process
See expert techniques for layout, UX, and interactivity
Learn how to craft truly impactful data stories with Power BI
🧠 Whether you're a Power BI beginner or a seasoned pro, this event is packed with inspiration, tips, and creative spark. 📅 Don't miss it — hit that reminder and join the chat live!
Injae Park is a Microsoft Data Platform MVP who combines his technical expertise with a passion for teaching by sharing his insights and practical tips through his YouTube channel @PowerBIPark. Injae's content ranges from beginner tutorials to advanced techniques, and as part of the Power BI Core Visual Representatives - he aims to bridge the MS Developer team with the Power BI community. His education in psychology and economics as well as his experience in consulting gives him a well-rounded perspective on the Power BI Developer experience, making his tutorials both engaging and accessible.
Shannon is a data and analytics witch with a background in global public health. She’s currently casting spells at Microsoft, working to ensure Power BI is accessible to all users. Shannon spends as much time as possible in the data community, participating in user groups and working with the fabulous Workout Wednesday team.
Lakshmi is a Microsoft MVP and certified Power BI specialist known for her creative, insight-driven reports. As a Product Lead, she combines her technical skills with a passion for storytelling and community engagement. A 2025 DataViz Championship finalist, she also shares tips on her blog and mentors aspiring professionals in the data space.
Javier is a certified Power BI instructor and founder of one of the largest Spanish-speaking data analytics academies. Originally from Mexico, he began his digital journey at age 9 and has since combined his background in engineering and business to empower others through data. Passionate about making analytics accessible, he now helps professionals visualize and understand their data using tools like Excel and Power BI.
Video by: Reid Havens
Wrap up the Power BI visual calculation series by drawing a variance line between the first and last values in your chart! In this tutorial, you’ll learn how to use two visual calcs to anchor the start and end points, then connect them with a custom line and error bars — perfect for highlighting overall change over time.
Visual Calcs in Power BI
Highlight First or Last Value Comparisons in Power BI with Visual Calcs!
Add Positive/Negative Color Error Bars Using Visual Calcs!
Many of us would prefer to avoid the topic of Power BI and Fabric licensing like the plague, and it's no wonder why. Between Premium, PPU, Pro, and Free options, Power BI licensing was already complicated enough. With the introduction of Fabric capacities and even more considerations to think through, it can quickly get overwhelming.
But fear not, the witch and wizard are in the house to break it down and simplify it for you by explaining the details and even providing a high-level calculator. We'll have an engaging discussion on some of the nuances and how to decide what you need so you'll be on your way and ready to make some decisions.
Stephanie is the co-founder and grand high witch at data-witches.com. She is a Microsoft Data Platform MVP who specializes in turning complex data into clear insights using Fabric and Power BI. Before becoming a full-time witch (and like so many of us in this field) she had a long and winding career path. In her case, it was mostly spent working on a shoestring budget at non-profits, where she learned how to get as much as possible accomplished with few resources (the inspiration for the licensing calculator). When not at her computer she can be found chasing after her kids, doing never-ending laundry, mixing cocktails, baking goodies, and planning her next adventure.
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.
