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

Power BI Custom Visuals Class (Module 15 – Table Heatmap)

Table Heatmap

In this module you will learn how to use the Table Heatmap Power BI Custom Visual.  The Table Heatmap has the look and feel of a pivot table or matrix report.  However, instead of seeing traditional values in the table you actually see colors that represent your values instead.

Module 15 – Table Heatmap


Key Takeaways

  • In the Table Heatmap the color of the boxes is determined by the value in your measure.
  • Only 1 category field can be used, which will dynamically generate the number of columns based on the number of distinct values your field has.
  • The number and types of colors can be changed using some of the settings we’ll discuss below.


This shows a Table Heatmap with Month as the category column and individual fields 2013, 2014, 2015, 2016 in the Y axis.

  • Under the Format paintbrush there isn’t much available to customize the appearance of the Table Heatmap.
  • The one section specific to the Table Heatmap that you have available is found under the General section.
    • By changing the Colorbrewer property you are able to swap out the color palette being used
    • You can also use the Buckets setting to increase/decrease the number of colors that are used in the color palette you’ve selected.


  • There are many color palettes that you can use in the Colorbrewer property but unfortunately they’re not well documented. Here’s a list of values that you could use in this property:
    • YlGn,
    • YlGnBu,
    • GnBu,
    • BuGn,
    • PuBuGn,
    • PuBu,
    • BuPu,
    • RdPu,
    • PuRd,
    • OrRd,
    • YlOrRd,
    • YlOrBr,
    • Purples, Blues, Greens, Oranges, Reds, Greys,
    • PuOr,
    • BrBG,
    • PRGn,
    • PiYG,
    • RdBu,
    • RdGy,
    • RdYlBu,
    • Spectral, RdYlGn,
    • Paired, Pastel1, Set1, Set2, Set
  • Experiment with these and see which makes most sense for your solution
  • In addition to these properties you have a set of settings that appears on every visual to adjust the background color, add a border around the visual and lock the aspect ratio.

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 20+ 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...