Heatmap row by row
Matrix Color Rules
Format
Overview
Features
Prompts
Troubleshooting
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 the same 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.
How it works
Type /row-by-row-matrix-cf, 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 (
_Color Red,_Color Green)Creates per-measure conditional formatting measures using the selected rule
Patches the visual.json with backColor entries for each measure
What you get
Shared color measures — reusable across multiple matrices
Per-measure CF measures — named
CF - {Measure} {Rule} by {Column}Patched visual — backColor 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) |
