SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Power BI Custom Visuals Class (Module 69 – Heatmap)

In this module you will learn how to use the Heatmap Custom Visual.  The Heatmap is useful for show data density on a map. It does this well because it aggregates data points and plots them to colors on a map.

Module 69 – Heatmap


Key Takeaways.

  • Shows density of data on a map.
  • Uses Bing Maps REST Services.
  • Ability to animate the Heatmap over time.


This Heatmap shows customers of various credit agencies and their complaints.

  • Under the Format paintbrush there are a several settings that you can configure to adjust the tooltip appearance.
  • Under the Legend setting you can change the appearance of the appears of the legend. You can change the position, font size, and what elements of the legend are actually displayed.


  • The Renderer properties allows you to change the type of maps that’s shown as well as how large each value is displayed and if the value on the map should be transparent. You can also select how you want to the aggregated values to be displayed using the Measure property.


  • Depending on the type of map you select in the Renderer section you will see either settings for Heat map or Contour map. These sections allow you to customize the way the thresholds are displayed for either map style.


  • If a column is placed in the Group field then that can be used to easily remove certain values from being displayed in the visual.


  • Under the Animation section you can control how the visual plays through the results on the visual. The Group field is what is used for the animation.


  • Finally the Map section allows you control the interactions users will have with the map. By changing the Zoom and Pan settings you can turn on/off the ability to freely move around the map.


You can also adjust the background color, add a border around the visual and lock the aspect ratio under the Format section.

Find Out More

You will always be able to find this video module and advanced viewing of future modules on the Pragmatic Works On Demand Training platform.  Click here to learn more about this training platform that includes 30+ courses.

Catch up on all the Power BI Custom Visuals blog posts here.

Devin Knight

Devin is a BI consultant at Pragmatic Works Consulting. Previously, he has tech edited the book Professional Microsoft SQL Server 2008 Integration Services and was an author in the book Knight's 24-Hour Trainer: Microsoft SQL Server 2008 Integration Services. Devin has spoken at past conferences like PASS and at several SQL Saturday events. He is a contributing member to the Business Intelligence Special Interest Group (SIG) for PASS as a leader in the SSIS Focus Group. Making his home in Jacksonville, FL, Devin is a participating member of the local users’ group (JSSUG).


Leave a comment on the original post [devinknightsql.com, opens in a new window]

Loading comments...