Posts filed under DAX

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

Box (and Whisker) Plot Visual with Native Visuals + Error Bars

Video by: Reid Havens

Learn how to leverage error bars and native visualizations to create a box and whisker style visualization using a bit of [DAX] magic. Tune in to learn more!

RELATED CONTENT 🔗

Create a Range Bar with Native Visuals
Box Chart
Daniel’s GitHub (PBIX File)
Daniel's Website
Deneb

Posted on December 17, 2024 and filed under Visualizations, DAX.