Matrix Heatmap
Matrix Color Rules
Overview
Features
Prompts
Help
Key Features
Power BI's built-in conditional formatting works column-by-column. Highlighting the highest value in each row across columns requires custom DAX measures that compare values within row context — 10 measures means 10 color measures, each with the same pattern but different references. This skill generates all the DAX and patches the visual automatically, with 10 rule types from simple min/max to full heatmap gradients — run it with /matrix-heatmap.
How it works
Type /matrix-heatmap, select your matrix visual, choose a rule type, and the skill creates everything:
Identifies all measures in the matrix and the column field (if present)
Creates shared color measures for the color scale endpoints
Creates per-measure conditional formatting measures using the selected rule
Patches the visual definition with background color entries for each
What you get
Shared color measures — reusable across multiple matrices
Per-measure conditional formatting measures — one per measure in the matrix
Patched visual — background color applied with proper selector bindings
Supported rules (10)
Rule | What it does |
|---|---|
Min/Max | Green for highest, red for lowest in each row |
Above Average | Green if above row average |
Above/Below Average | Green above, red below |
Positive/Negative | Green for >= 0, red for < 0 |
Top N | Highlight top N values per row |
Top N Graduated | Gradient from dark to light for top N |
Bottom N | Highlight bottom N values per row |
Above Threshold | Red if above a specified value |
Below Threshold | Green if below a specified value |
Heatmap Gradient | Color scale from green (min) to red (max) |
Explore more in this category
Tool Information
Skill
39 USD
Bundle (All skills)
129 USD
Category
Format
Version
Version 2.1.1.2.15
or log in if you already have an account