Heatmap Visual in Power BI - Part I | Replicate "Busyness Chart" for a Post Office
While by default there is no heatmap visual option in Power BI, with some smarts (or tinkering) we can achieve a pretty good looking dataviz.
In this tutorial I show you how to get started with the matrix visual and apply some conditional formatting logic to the background colour and the font colour to achieve a heatmap-style visual element.
Stay tuned for Part II where we take the existing heatmap and fine-tune it to a more presentable format, something that we can share on a website or publish to web.
Have a good one,
Roland
💪 New videos coming every Tuesday 🤹♂
🤘 New short videos coming every week 👨🏫
📝 BLOG POST: https://bilingualanalytics.com.au/hea...
🎬 MORE VIDEOS:
Power BI & Power Automate - How to automate reporting process -
• Power BI & Power Automate - How to au...
Power BI Web Scraping With Power Automate Alerts | How To Buy A 40 Series GPU Without Coding - • Power BI Web Scraping With Power Auto...
Dynamic Row-level Security 🔐 - Based on Dimension Tables - • Dynamic Row-level Security 🔐 - Based ...
Chapters:
00:00 Topic Of The Day - Heatmap Visual
00:32 Intro
00:42 BI-Lingual Analytics
01:00 Heatmap Matrix
01:21 Dummy Data Used
02:08 Get Started
02:45 Date And Time Column Creation
03:40 Create a Date Table
04:15 Create a Time Table
04:50 Relationships And DAX Measure
05:11 First Look At The Heatmap Matrix
05:42 Conditional Formatting Power BI Matrix
07:15 Final Tuning
07:51 Data Visualization in Power BI
08:07 What's Next?
08:36 Questions? Comments?
08:48 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: https://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