Posts filed under Visualizations

Fixed-Window Charting in Power BI: Auto-Adjusting Calendar Periods

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!

RELATED CONTENT 🔗

Creating a MTD/QTD/YTD Time Intelligence Slicer

Posted on January 28, 2025 and filed under DAX, Data Modeling, Visualizations.

(Livestream Replay) Auto-magically Checking For Broken Visuals in Power BI - with John Kerski

DESCRIPTION 📄

A.K.A - Avoiding the "Grey Box of Death!"

Have you ever updated a semantic model/dataset and didn't realize it broke a visual in a Power BI report? Have you ever seen that "grey box of death" (or your customers call you about it) after making an update to Power BI? In this session, I demonstrate a way to combine Microsoft Playwright and Azure DevOps to automatically test for broken visuals and notify you about those issues.

GUEST BIO 👤

John leverages his 10+ years of technical and government leadership experience to help Federal Agencies, and private sector clients utilize Microsoft products to their fullest potential. His certifications with Microsoft products offers customers a high rate of return when looking to invest in Microsoft solutions.

RELATED CONTENT 🔗

Blog
LinkedIn
Test for Broken Visuals
Automate with DevOps

Posted on January 24, 2025 and filed under Livestreams, Visualizations, Azure.

Creating a Dynamic Label Toggle Button Using ONE VISUAL!

Video by: Reid Havens

Learn how to leverage the newer tile slicer (thanks #PBICoreVisuals Team!), a bit of [DAX] Magic, and some clever techniques to create a single button toggle slicer using only a single visual! Plus, this single button even has a dynamic (on/off) label. Tune in to learn more!

RELATED CONTENT 🔗

Microsoft Learn: Field Parameters
Button Slicer

Posted on January 7, 2025 and filed under Visualizations, Power BI.

Waterfall Charts with Categories (and Considerations...)

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!

RELATED CONTENT 🔗

Vertical Waterfall Charts with Visual Calcs