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.

(Livestream Replay) Introduction to Fabric Studio - with Gerhard Brueckl

DESCRIPTION πŸ“„

In this session I will give you an introduction to the Visual Studio Code extension "Fabric Studio" which allows you to manage your Fabric environment directly from within VSCode. Leveraging the Fabric REST APIs you can easily browse through Fabric items and run various tasks. For not so common API calls there is also the ability to user VSCode notebooks offering intelli-sense and auto-complete from all existing API calls. It further allows you to modify existing items like semantic models, notebooks, pipelines, etc. in the VSCode IDE and publish your changes back to the Fabric service. It also features a OneLake browser to inspect the output of your operations.

GUEST BIO πŸ‘€

Gerhard has been working with the Microsoft Data Platform for almost 20 years. From building traditional BI/DWH solution on the MSSQL server stack to designing and implementing whole data platforms hosted in the Microsoft Azure cloud. He is also familiar with OSS technologies in that area like Hadoop, Spark and Delta Lakes. When not working on customer projects, Gerhard is an active member in the community and shares his knowledge in his blog or when speaking at conferences and meet-ups.

RELATED CONTENT πŸ”—

LinkedIn
Blog
GitHub
FabricStudio VSCode Marketplace

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.