Working with Heat Maps

About Heat Maps

A heat map displays the distribution of values for two data items by using a table with colored cells. If you do not assign a measure to the Color data role, then a cell’s color represents the frequency of each intersection of values. If you assign a measure to the Color data role, then a cell’s color represents the aggregated measure value for each intersection of values.

Data Roles for a Heat Map

The basic data roles for a heat map are:
X axis
specifies the data item that is assigned to the X axis.
specifies the data item that is assigned to the Y axis.
Color
specifies a measure that determines the cell color. If you do not assign the Color role, then the cell color indicates frequency.

Specify Properties for a Heat Map

On the Properties tab, you can specify the following options:
Name
specifies the name of the visualization.
Title
specifies the title that appears above the graph.
Note: The Title option is disabled if you select Generate graph title.
Generate graph title
specifies that the graph title is generated automatically based on the data items in the visualization.
Bin count
specifies the number of value ranges that are represented as cells. Bin count affects only measures.
specifies that the borders between cells are visible.
displays the category labels at an angle.
Note: The Rotate axis labels option affects only the values on the X axis.
Note: The Rotate axis labels option has no effect if the heat map contains no categories.
selects the gradient colors for the visualization.
You can click the Edit color gradient button to select the values that are used to assign the colors. See Specify a Custom Data Range.
adds a fit line to the heat map. For information about the fit types that are available, see Fit Lines.
Note: Fit lines are not available if a category is assigned to the heat map.

Applying Data Analysis

About Data Analysis

For heat maps, you can apply the following data analyses:
Correlation
identifies the degree of statistical correlation between the variables in the visualization. For more information, see Correlation.
Fit Line
plots a model of the relationship between the variables in the visualization.
There are many types of fit lines, including linear fit, quadratic fit, cubic fit, and penalized B-spline. For more information, see Fit Lines.
Correlation is applied to your visualization automatically when you add a linear fit line. It is not available with other fit types.

Enable Data Analysis

To add a fit line to your visualization, select the Options drop-down list from the visualization toolbar, and then select Fit Linethen selectfit-type. For information about the fit types that are available, see Fit Lines.
Note: Fit lines are not available if your heat map contains categories or hierarchies.
Last updated: January 8, 2019