Posts filed under DAX

Highlight First or Last Value Comparisons in Power BI with Visual Calcs!

Video by: Reid Havens

Learn how to compare the first or last values in a Power BI chart using visual calculations! In this tutorial, I’ll walk you through adding a dynamic line marker and error bar comparison that highlights the change from beginning to end, perfect for trend visuals and executive summaries.

RELATED CONTENT 🔗

Visual Calcs in Power BI

Posted on June 17, 2025 and filed under DAX, Visualizations.

Invisible (and Built-In) Categorical Sorting Trick for Columns in Power BI

Video by: Reid Havens

Ever wanted your matrix or table in Power BI to sort by a hidden value — without showing that value in the visual? In this video, I’ll show you a powerful trick using zero-width Unicode characters to embed an invisible sort order directly into your categorical columns.

We’ll walk through a demo using a dataset of transaction IDs and regions, and show how you can control sort behavior without cluttering your visuals. Tune in to learn more!

RELATED CONTENT 🔗

Built-In Sort for Columns

Posted on June 3, 2025 and filed under DAX, Design & Presentation.

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.

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