{ "api_version": "1", "kind": "dse_post", "self": "https://update.dsesecurity.com/api/v1/posts/dse-20260909-424-use-a-shared-heatmap-scale-when-workbook-columns-must-be-compared/", "item": { "id": "https://update.dsesecurity.com/updates/dse-20260909-424-use-a-shared-heatmap-scale-when-workbook-columns-must-be-compared/", "slug": "dse-20260909-424-use-a-shared-heatmap-scale-when-workbook-columns-must-be-compared", "url": "https://update.dsesecurity.com/updates/dse-20260909-424-use-a-shared-heatmap-scale-when-workbook-columns-must-be-compared/", "alternate_urls": { "markdown": "https://update.dsesecurity.com/updates/dse-20260909-424-use-a-shared-heatmap-scale-when-workbook-columns-must-be-compared.md", "json": "https://update.dsesecurity.com/api/v1/posts/dse-20260909-424-use-a-shared-heatmap-scale-when-workbook-columns-must-be-compared/" }, "title": "Use a shared heatmap scale when workbook columns must be compared", "summary": "Do equally colored cells in separate workbook columns necessarily represent equal values?", "format": { "slug": "guide", "name": "Guide" }, "priority": { "slug": "info", "name": "Information" }, "featured": false, "image": { "theme": "managed-it", "label": "Managed IT operations", "alt": "A controlled technology lifecycle progressing from assessment to approved production.", "card_url": "https://update.dsesecurity.com/assets/editorial/managed-it-card.webp?v=1.8.20", "hero_url": "https://update.dsesecurity.com/assets/editorial/managed-it-hero.webp?v=1.8.20", "social_url": "https://update.dsesecurity.com/assets/editorial/managed-it-social-v2.jpg?v=1.8.20", "width": 2400, "height": 1350 }, "topics": [ { "slug": "it", "name": "IT", "url": "https://update.dsesecurity.com/topic/it/" } ], "author": { "name": "DSE Security Editorial Team", "url": "https://update.dsesecurity.com/#editorial-team", "type": "Organization" }, "publisher": { "name": "Detection Systems & Engineering", "url": "https://dsesecurity.com/" }, "published_at": "2026-09-10T00:24:52+00:00", "modified_at": "2026-09-10T02:04:57+00:00", "reviewed_on": "2026-09-09", "reading_minutes": 2, "word_count": 227, "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.", "primary_source": { "name": "Azure Monitor workbook grid visualizations - Azure Monitor | Microsoft Learn", "url": "https://learn.microsoft.com/en-us/azure/azure-monitor/visualize/workbooks-grid-visualizations", "published_on": null, "authority": "Microsoft Learn" }, "publishing_principles": "https://update.dsesecurity.com/updates/dse-updates-editorial-methodology/", "usage_info": "https://update.dsesecurity.com/usage/", "copyright_notice": "Copyright © 2026 Detection Systems & Engineering. All rights reserved.", "content_html": "

Source facts

\n

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.

\n

Applicability

\n

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.

\n

DSE recommendation

\n

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.

\n

Verification

\n

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.

\n

Official references

\n

Microsoft Learn: Workbook grid visualizations. Source reviewed September 9, 2026.

", "content_text": "Source facts\nThe 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.\nApplicability\nReview 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.\nDSE recommendation\nChoose 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.\nVerification\nBuild 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.\nOfficial references\nMicrosoft Learn: Workbook grid visualizations. Source reviewed September 9, 2026.", "content_markdown": "## Source facts\n\nThe 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).\n\n## Applicability\n\nReview 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.\n\n## DSE recommendation\n\nChoose 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.\n\n## Verification\n\nBuild 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.\n\n## Official references\n\n[Microsoft Learn: Workbook grid visualizations](https://learn.microsoft.com/en-us/azure/azure-monitor/visualize/workbooks-grid-visualizations). Source reviewed September 9, 2026." }, "json_ld": { "@context": "https://schema.org", "@graph": [ { "@type": "Organization", "@id": "https://dsesecurity.com/#organization", "name": "Detection Systems & Engineering", "alternateName": "DSE Security", "url": "https://dsesecurity.com/", "logo": { "@type": "ImageObject", "url": "https://update.dsesecurity.com/assets/dse-logo-20260812.png?v=1.8.20" } }, { "@type": "Organization", "@id": "https://update.dsesecurity.com/#editorial-team", "name": "DSE Security Editorial Team", "url": "https://update.dsesecurity.com/", "parentOrganization": { "@id": "https://dsesecurity.com/#organization" } }, { "@type": "WebSite", "@id": "https://update.dsesecurity.com/#website", "name": "DSE Updates", "alternateName": "DSE Security Knowledge Hub", "url": "https://update.dsesecurity.com/", "inLanguage": "en-US", "publisher": { "@id": "https://dsesecurity.com/#organization" }, "potentialAction": { "@type": "SearchAction", "target": { "@type": "EntryPoint", "urlTemplate": "https://update.dsesecurity.com/?q={search_term_string}" }, "query-input": "required name=search_term_string" } }, { "@type": "WebPage", "@id": "https://update.dsesecurity.com/updates/dse-20260909-424-use-a-shared-heatmap-scale-when-workbook-columns-must-be-compared/", "url": "https://update.dsesecurity.com/updates/dse-20260909-424-use-a-shared-heatmap-scale-when-workbook-columns-must-be-compared/", "isPartOf": { "@id": "https://update.dsesecurity.com/#website" }, "lastReviewed": "2026-09-09" }, { "@type": "BreadcrumbList", "@id": "https://update.dsesecurity.com/updates/dse-20260909-424-use-a-shared-heatmap-scale-when-workbook-columns-must-be-compared/#breadcrumbs", "itemListElement": [ { "@type": "ListItem", "position": 1, "name": "DSE Updates", "item": "https://update.dsesecurity.com/" }, { "@type": "ListItem", "position": 2, "name": "Use a shared heatmap scale when workbook columns must be compared", "item": "https://update.dsesecurity.com/updates/dse-20260909-424-use-a-shared-heatmap-scale-when-workbook-columns-must-be-compared/" } ] }, { "@type": [ "Article", "TechArticle" ], "@id": "https://update.dsesecurity.com/updates/dse-20260909-424-use-a-shared-heatmap-scale-when-workbook-columns-must-be-compared/#article", "identifier": "https://update.dsesecurity.com/updates/dse-20260909-424-use-a-shared-heatmap-scale-when-workbook-columns-must-be-compared/", "url": "https://update.dsesecurity.com/updates/dse-20260909-424-use-a-shared-heatmap-scale-when-workbook-columns-must-be-compared/", "headline": "Use a shared heatmap scale when workbook columns must be compared", "description": "Do equally colored cells in separate workbook columns necessarily represent equal values?", "abstract": "Do equally colored cells in separate workbook columns necessarily represent equal values?", "articleBody": "Source facts\nThe 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.\nApplicability\nReview 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.\nDSE recommendation\nChoose 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.\nVerification\nBuild 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.\nOfficial references\nMicrosoft Learn: Workbook grid visualizations. Source reviewed September 9, 2026.", "datePublished": "2026-09-10T00:24:52+00:00", "dateModified": "2026-09-10T02:04:57+00:00", "mainEntityOfPage": { "@id": "https://update.dsesecurity.com/updates/dse-20260909-424-use-a-shared-heatmap-scale-when-workbook-columns-must-be-compared/" }, "inLanguage": "en-US", "isAccessibleForFree": true, "author": { "@type": "Organization", "name": "DSE Security Editorial Team", "url": "https://update.dsesecurity.com/#editorial-team" }, "publisher": { "@id": "https://dsesecurity.com/#organization" }, "image": { "@type": "ImageObject", "@id": "https://update.dsesecurity.com/updates/dse-20260909-424-use-a-shared-heatmap-scale-when-workbook-columns-must-be-compared/#primaryimage", "url": "https://update.dsesecurity.com/assets/editorial/managed-it-social-v2.jpg?v=1.8.20", "contentUrl": "https://update.dsesecurity.com/assets/editorial/managed-it-social-v2.jpg?v=1.8.20", "width": 1200, "height": 630, "caption": "Use a shared heatmap scale when workbook columns must be compared" }, "articleSection": [ "IT" ], "keywords": [ "IT", "Guide", "Information priority" ], "genre": "Guide", "about": [ { "@type": "Thing", "name": "IT", "url": "https://update.dsesecurity.com/topic/it/" } ], "wordCount": 227, "timeRequired": "PT2M", "publishingPrinciples": "https://update.dsesecurity.com/updates/dse-updates-editorial-methodology/", "usageInfo": "https://update.dsesecurity.com/usage/", "copyrightHolder": { "@id": "https://dsesecurity.com/#organization" }, "copyrightNotice": "Copyright © 2026 Detection Systems & Engineering. All rights reserved.", "citation": { "@type": "CreativeWork", "name": "Azure Monitor workbook grid visualizations - Azure Monitor | Microsoft Learn", "url": "https://learn.microsoft.com/en-us/azure/azure-monitor/visualize/workbooks-grid-visualizations" } } ] } }