---
title: Power BI Custom Visuals - Table Heatmap
description: Learn about the Power BI Custom Visual, Table Heatmap.
---

[Pragmatic Works Nerd News ](https://pragmaticworks.com/blog)

# [Power BI Custom Visuals - Table Heatmap](https://pragmaticworks.com/blog/power-bi-custom-visuals-table-heatmap)

 Written by [Devin Knight](https://pragmaticworks.com/blog/author/devin-knight) | Sep 08, 2016

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

### Downloads

- Power BI Custom Visual – [Table Heatmap](https://pragmaticworksonline.sharepoint.com/:f:/s/FileShare/Ejn3BZIKy-NHk0DHsQUqT5QBx8WaO5HCyu0Qo7pWOzaWmw?e=v4PKvj)
- Dataset – [Monthly Sales.xlsx](https://pragmaticworksonline.sharepoint.com/:f:/s/FileShare/Eqepmh2epHhJknRvZzNGtB8BapbJmrqBEaIRcVvQUnyi9g?e=y5cKXe)
- Completed Example – [Module 15 – Table Heatmap.pbix](https://pragmaticworksonline.sharepoint.com/:f:/s/FileShare/Eqepmh2epHhJknRvZzNGtB8BapbJmrqBEaIRcVvQUnyi9g?e=y5cKXe)

### 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.

<https://devinknightsql.files.wordpress.com/2016/09/image.png>

*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.

<https://devinknightsql.files.wordpress.com/2016/09/image1.png>

- 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 or [view my previous blog posts](https://blog.pragmaticworks.com/topic/power-bi-custom-visuals).

[View full post](https://pragmaticworks.com/blog/power-bi-custom-visuals-table-heatmap)

```json
{
  "@context" : "http://schema.org",
  "@type" : "BlogPosting",
  "author" : {
    "@type" : "Person",
    "name" : "Devin Knight"
  },
  "dateModified" : "2023-03-28T14:01:13.847Z",
  "datePublished" : "2016-09-08T13:37:44Z",
  "headline" : "Power BI Custom Visuals - Table Heatmap",
  "image" : {
    "@type" : "ImageObject",
    "height" : 200,
    "url" : "http://blog.pragmaticworks.com/hubfs/Banners/Power-BI-Banner.jpg",
    "width" : 600
  },
  "mainEntityOfPage" : "https://pragmaticworks.com/blog/power-bi-custom-visuals-table-heatmap",
  "publisher" : {
    "@type" : "Organization",
    "logo" : {
      "@type" : "ImageObject",
      "height" : 60.0,
      "url" : "https://blog.pragmaticworks.com/hubfs/PW%20Logo-2.png",
      "width" : 217.56097
    },
    "name" : "Pragmatic Works Blog"
  }
}
```