Posts filed under DAX

Create a Variance Line ONLY Between First and Last Values in Power BI

Video by: Reid Havens

Wrap up the Power BI visual calculation series by drawing a variance line between the first and last values in your chart! In this tutorial, you’ll learn how to use two visual calcs to anchor the start and end points, then connect them with a custom line and error bars — perfect for highlighting overall change over time.

RELATED CONTENT 🔗

Visual Calcs in Power BI
Highlight First or Last Value Comparisons in Power BI with Visual Calcs!
Add Positive/Negative Color Error Bars Using Visual Calcs!

Posted on July 15, 2025 and filed under DAX, Visualizations.

Add Positive/Negative Color Error Bars Using Visual Calcs!

Video by: Reid Havens

Take your Power BI visuals to the next level by applying dynamic positive/negative color formatting to your first-to-last comparison line! This tutorial expands on the previous visual calculation setup by adding conditional color cues to highlight trends at a glance, great for dashboards and storytelling. Tune in to learn more!

RELATED CONTENT 🔗

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

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.