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