Matrix Heatmap
Matrix Color Rules
Overview
Features
Prompts
Help
Key Features
Add row-by-row conditional formatting to a matrix or table — highest in green, lowest in red, or a full heatmap — with the DAX written and the visual wired for you.
Power BI's built-in conditional formatting works down a column, but a matrix reads across the row — you want the biggest number in each row to stand out against the others beside it. Doing that means custom DAX that compares values within each row's context, one colour measure per value column, then hand-wiring each one into the visual's background-colour bindings. This skill writes all of it and patches the visual for you, across 10 rule types from a simple min/max to a 10-step heatmap — on matrices and tables alike — run it with /matrix-heatmap.
How it works
Type /matrix-heatmap, point it at your matrix (or table), pick a rule, and the skill builds everything:
Reads the visual — finds the value measures, the column field (matrices) or row fields (tables), and how they relate to the measures' table
Asks two things — which of the 10 rules to apply (with any parameter, like Top N or a threshold) and which display folder the new measures go in (default
_CF)Writes the colour DAX — a conditional-formatting measure per value column that returns a colour by the rule (blank cells left uncoloured), plus the shared red/green colour measures
Wires the visual — binds each value column's background colour to its measure
Adds a title and subtitle — a title naming the measures and column, and a subtitle spelling out the active rule (e.g. "Top 3 — green for top 3 values per row")
What you get
A colour-formatted matrix (or table) — each row's cells shaded by the rule you picked
The colour DAX behind it — one conditional-formatting measure per value column, in a
_CFfolder, plus shared red/green colour measuresA title and subtitle — the title names the measures and column; the subtitle describes the rule so readers know what the colours mean
Clean bindings — each value column bound to its own colour measure, blank cells left uncoloured
Supported rules (10)
Rule | What it does |
|---|---|
Min/Max | Green for highest, red for lowest in each row |
Above Average | Green if above the row average |
Above/Below Average | Green above, red below the row average |
Positive/Negative | Green for ≥ 0, red for < 0 |
Top N | Green for the top N values per row |
Top N Graduated | Dark-to-light green gradient for the top N |
Bottom N | Red for the bottom N values per row |
Above Threshold | Green if the value is above your threshold |
Below Threshold | Red if the value is below your threshold |
Heatmap Gradient | 10-step colour scale, red (low) → green (high) |
Tool Information
Skill
39 USD
Bundle (All skills)
249 USD
Category
Format
Version
Version 4.2.2.2.6.2
or log in if you already have an account