Posts filed under Visualizations

(Livestream Replay) Building Income Statements in Power BI - with Chris Barber

DESCRIPTION 📄

Profitability is a key metric for any business, as profits can be distributed back to shareholders either directly or indirectly. An income statement—also known as a Profit and Loss (P&L) statement—answers high-level questions such as “What was our net profit last year?” while summarizing key revenue (e.g., product revenue) and expense (e.g., R&D) items.

Unlike static reports, a P&L semantic model provides granular detail, enabling users to explore insights such as “How was R&D spending distributed across projects, fiscal periods, or legal entities?” With a well-structured model, users can analyze financials dynamically through Power BI reports, PivotTables, and Excel formulas.

GUEST BIO 👤

Chris Barber is a Chartered Accountant (ACMA, CGMA), four-time Microsoft MVP, and author of Income Statement Semantic Models. He runs StarSchema.co.uk and has created popular YouTube videos (100K+ views) and courses (1K+ participants) focused on building Profit and Loss (P&L) reports in Power BI.

RELATED CONTENT 🔗

Website
Linkedin

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.