In the earlier sections, we read about the Text table, which just shows numbers. Then we read about the Highlight table where we used a color in addition to the text to find out which values were high and which values were low. A Heat map is a step advanced than the Highlight table. With a Heat map, we can compare both the size and color values. In a Heat map, we can also compare two different Measures for a combination of Dimensions.
To create a Heat map, we will compare Sales and Profit for product categories across Regions. Let's understand how to build a Heat map.
Heat map
.Size in the preceding image shows Sales and Color indicates profit. Thus, the bigger the square, more the sales, and the darker the blue square, the greater the profit.
In the preceding image, we can see that Furniture in the Central region is light orange in color, indicating that it is a non-profitable venture. Further, Technology in the East region has the biggest square, which indicates that it has the highest number of sales among other categories across regions.