QT#82 – Improving the Design of a matrix visual HEAT MAP in Power BI

In this video, you'll learn some ideas for improving the standard default heatmap design.

The default formatting options applied if you use one of the standard Power BI desktop templates are ok, but in my opinion, leave room for improvement.

A heat map can be created using a Matrix visual. The main purpose of a heat map is to use a background colour to draw attention to numbers that are of interest. The background colour of each cell represents the magnitude of the number related to the row and column category values.

In this example, we are displaying open work orders by department and discipline. The purpose of this heat map visual is to understand the combinations of department and discipline which have the highest number of work orders.

In this video, I'll walk you step by step through some approaches that I like to take that can increase the readability of your heatmaps.

See the resources section here to download the pbix file and theme.

{"email":"Email address invalid","url":"Website address invalid","required":"Required field missing"}

Recent Posts

About the author 

Jason Davidson

Jason Davidson is the founder of EffectiveDashboards.com. He is a maintenance and reliability engineer who uses Power BI every day to create dashboards that help him and others make better decisions. In his spare time, he likes running and has recently got into photography. He also loves spending time hanging out and larking about with his two daughters.

FREE Power BI Quick Start Course

Learn how to build a Power BI dashboard in under 90 minutes.