Heatmap Visual in Power BI - Part III | Dynamic Heatmap Legend with Calculation Groups

This is the third part of a series about Heatmap visual in Power BI.
In the first episode, we talked about how to create it using a matrix visual, and in the second one, I showed you one way to "upgrade" your report design.
Today, my friend from the Power BI community, Barnabas, will walk you through a further enhancement.
Namely how to create a dynamic color scale legend based on user selection. The legend respects both filtering on dimensional attributes and measure selectors as well. Throughout the video, we provide the evolution of approaches (multiple measures, SWITCH statement, Calculation Groups, Precedence property). Some rely on Power BI Desktop alone, while towards the end we are using Tabular Editor which helps to extend our capabilities beyond what we have out of the box. Following through you can also create your own implementation that will yield better code readability, easier maintenance, and so much more analytical power. Tune in!
We hope you enjoy this one!
Have a good one,
Roland & Barnabas
💪 New videos coming every week 🤹‍♂‍
🤘 New short videos coming every week 👨‍🏫
🔗 LINKS:
LinkedIn Barnabas: / barnabas-toth
Starschema: starschema.com/
📝 BLOG POST:
🎬 MORE VIDEOS:
Power BI & Power Automate - How to automate reporting process -
• Power BI & Power Autom...
Power BI Web Scraping With Power Automate Alerts | How To Buy A 40 Series GPU Without Coding - • Power BI Web Scraping ...
Dynamic Row-level Security 🔐 - Based on Dimension Tables - • Dynamic Row-level Secu...
Chapters:
00:00 Topic Of The Day - Heatmap Visual III
00:29 Intro
00:39 BI-Lingual Analytics
01:02 Barnabas Intro
01:28 Current Setup - Static Legend
02:48 Idea - Dynamic Heatmap Legend
03:12 Legend as a Matrix
04:59 Create Calculation Group
09:50 Tweak CalcGroup
12:23 Final Result
12:56 Wrap-up
13:15 Final Words - Questions? Comments?
13:37 End
▼▼▼▼▼▼▼▼▼
Make sure to hit the 👍 button and ❗❗ SUBSCRIBE ❗❗ to my channel.
If you have any questions, just let me know either in the comments down below 👇 or send us an e-mail 📩.
▲▲▲▲▲▲▲▲▲
🤝 HOW TO CONNECT 🤝
LinkedIn - / bilingualanalytics
Twitter - / bilanalytics
Subscribe - / @bilingualanalytics
ABOUT ME: bilingualanalytics.com.au/abo...
📍 - Sydney, Australia
📽 GEAR:
📷 - Sony ZV-E10
🎙 - Audio Technica AT2020
🔦 - Neewer 18” Ring Light, Elgato Key Light
🎧 - BOSE QC35
🖥 - ASUS VC279H + Xiaomi Mi Curved 34"
💻 - Intel i7-12700K, Gigabyte Aorus Master 3080 12GB, Corsair Vengeance LPX 64GB, Samsung 980Pro 1TB
#PowerBI #DataViz #BILingualAnalytics

[@BILingualAnalytics]

Don't forget to drop a like and say Hi! 👋 to Barnabas as well!

[@AppForging]

Hi! :)

[@BILingualAnalytics]

Hello!