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

Download Report From The Blog Files Page
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

Download Report From The Blog Files Page
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

Download Report From The Blog Files Page

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

Download Report From The Blog Files Page
Posted on December 17, 2024 and filed under Visualizations, DAX.