# Use a shared heatmap scale when workbook columns must be compared

> Do equally colored cells in separate workbook columns necessarily represent equal values?

- Canonical URL: https://update.dsesecurity.com/updates/dse-20260909-424-use-a-shared-heatmap-scale-when-workbook-columns-must-be-compared/
- Publisher: Detection Systems & Engineering (DSE Security)
- Author: DSE Security Editorial Team
- Published: 2026-09-10T00:24:52+00:00
- Modified: 2026-09-10T02:04:57+00:00
- Last reviewed by DSE: 2026-09-09
- Resource type: Guide
- DSE priority: Information
- Topics: IT
- Reading time: 2 minutes

## What you need to know

Do equally colored cells in separate workbook columns necessarily represent equal values?

## Potentially affected

Azure Monitor workbook grids displaying numeric columns with heatmap renderers.

## DSE recommendation

Choose explicitly between within-column emphasis and cross-column comparison before applying a heatmap palette.

## Article

## Source facts

The workbook heatmap renderer colors a cell relative to its column’s minimum and maximum, using configured or calculated bounds. Microsoft’s shared-scale procedure selects multiple columns with a regular expression and removes their individual default settings. The resulting multicolumn setting supplies a common scale. A matching color across independently scaled columns is therefore not, by itself, an equality test. [Microsoft Learn](https://learn.microsoft.com/en-us/azure/azure-monitor/visualize/workbooks-grid-visualizations).

## Applicability

Review grids whose readers compare related numeric columns, such as several duration statistics. Identify each column’s units, renderer, bounds, and individual overrides. Keep unlike quantities separate unless the report explicitly explains the intended visual relationship.

## DSE recommendation

Choose explicitly between within-column emphasis and cross-column comparison before applying a heatmap palette. For comparable columns, review a shared-scale configuration and remove competing individual settings through the documented procedure. Retain the numeric values and units so color supplements the evidence instead of replacing it. Have the report owner explain the scale in the reader-facing description.

## Verification

Build a controlled result set containing equal values in different columns and deliberately different column ranges. Compare the initial rendering with the shared-scale version, checking both equal and unequal values. Add a new matching column to test the selection expression. Preserve the settings and visual comparison, and confirm that an unrelated count column did not inherit a scale intended for duration.

## Official references

[Microsoft Learn: Workbook grid visualizations](https://learn.microsoft.com/en-us/azure/azure-monitor/visualize/workbooks-grid-visualizations). Source reviewed September 9, 2026.

## Primary reference

- Name: Azure Monitor workbook grid visualizations - Azure Monitor | Microsoft Learn
- Authority: Microsoft Learn
- URL: https://learn.microsoft.com/en-us/azure/azure-monitor/visualize/workbooks-grid-visualizations
- Source publication date: Not stated by the source

## Citation and use

Preferred citation: “Use a shared heatmap scale when workbook columns must be compared,” DSE Security, https://update.dsesecurity.com/updates/dse-20260909-424-use-a-shared-heatmap-scale-when-workbook-columns-must-be-compared/
Publishing principles: https://update.dsesecurity.com/updates/dse-updates-editorial-methodology/
Usage and citation policy: https://update.dsesecurity.com/usage/
Copyright © 2026 Detection Systems & Engineering. All rights reserved.