Join the channel to get access to perks:
https://www.youtube.com/channel/UCvD2rJJrp0aS48-KCk0eMHQ/join
In this in-depth Power BI tutorial, you'll learn how to dynamically flag the highest values in your visuals using both DAX formulas and the emerging visual level calculations feature. The walkthrough demonstrates how changing selections automatically updates highlighted peaks, enhancing interactivity. While visual calcs are still a preview feature with a few quirks, this video dives into how to enable and apply them to streamline conditional formatting, saving you from complex DAX.
You’ll also explore some common bugs and limitations with visual level calcs, like disappearing formulas and restricted field references, along with clever workarounds. Plus, there’s a bonus trick on how to use a global color highlight measure, so you can instantly update your report's theme. Whether you're an experienced Power BI user or experimenting with visuals, this practical guide will help you level up your reporting game.
SQLBI BLOG:
https://www.sqlbi.com/articles/using-visual-calculations-for-conditional-formatting/
00:00 Introduction
00:24 Flagging Highest Values Dynamically
01:00 Enabling Visual Level Calculations (Preview Feature)
01:59 Writing Your First Visual Calc Formula
03:34 Using Hex Colors for Conditional Formatting
05:03 Fixing Field Value Display & Data Type Issues
07:15 Referencing Global Color Measures
09:30 Visual Calc Quirks and Bugs Explained
10:45 Comparing DAX vs Visual Calcs
The team and I at Access Analytic develop Power BI and Excel solutions for clients in Australia and deliver training around the World. https://accessanalytic.com.au/
Did you know I've written a book "Power BI for the Excel Analyst"?
https://pbi.guide/book/
Connect with me
https://wyn.bio.link/