Conditional formatting colors values according to rules that you define — so the number speaks up on its own when it crosses a threshold. In ingestia.bi it comes in three forms: per-column rules, heat scale and data bars. It's most useful in tables, matrices and heatmaps.
Examples use the synthetic workspace Comércio Aurora Ltda (aurora), the vendas table
and the produtos and filiais dimensions.
What it is#
A way to change a cell's background color, text color or icon based on its value, without writing code. It's the equivalent of conditional formatting in Power BI/Excel, applied per column of the visual.
What it's for#
- Flagging KPIs that miss the target (red below X, green above).
- Ranking a column visually (a proportional bar on each row).
- Creating a "heat map" in a matrix to spot the hot spot instantly.
When to use it / when not to#
- Use it in dense tables/matrices, where reading number by number is slow.
- Avoid overdoing it: too much color becomes noise. Save highlighting for what requires action. For accessibility, don't rely only on color — combine it with an icon (see Accessibility).
The three forms#
1. Per-column rules
You define a list of rules for a numeric column. Each rule is
column · operator · value · color (plus an optional icon: up arrow, down
arrow or dot). Evaluation follows the Power BI rule: the first rule that matches
the value wins — that's why order matters (put the most specific condition
first).
Available operators: >, >=, <, <=, =, !=.
Example (column "Margem %"):
| Order | Rule | Color | Icon |
|---|---|---|---|
| 1 | < 0 | red | ▼ |
| 2 | < 10 | amber | • |
| 3 | >= 10 | green | ▲ |
A margin of -2% matches rule 1 (red ▼); 7% matches rule 2 (amber •); 18% matches
rule 3 (green ▲).
Note
Colors go through theme sanitization (the same protection as the dashboard's palette) — you can't inject an arbitrary color value. Use the theme colors to keep the dashboard consistent.
2. Heat scale
Applies a continuous color scale to numeric cells: low values at one end of the scale, high values at the other. Ideal in a matrix (e.g., category × month) to see concentration without reading every number. It's the mechanism of the heatmap visual, available as an option in tables/matrices.
3. Data bars
Draws a proportional bar inside the cell itself, like a mini column. The width reflects the value relative to the column. Great for rankings ("which branch sells the most") without leaving the table.
Step by step#
Choose the visual
In edit mode, click a table, matrix or KPI. On a chart, first turn on Show as table (right-click the visual).
Open the section
In the visual pane, Format tab, open Conditional formatting. The section says how many rules already exist.
Click Open rules…
The rules open in a small window on top of the pane, with room for each row's controls. The same applies from the Format → Rules ribbon.
Set the type
Choose rules (color/icon by range), heat scale or data bar, on the numeric column you want to highlight.
Order the rules
If you use rules, put the most specific condition at the top — the first one that matches wins.
Close and check
Close the small window with ✕, click Apply and check the highlighting on the rows.
On a chart the rule doesn't show
The rule is only drawn on a KPI, table, matrix or with Show as table on. On a chart, the section warns: "Works on KPI, table, matrix or with "Show as table" on."
Example (synthetic)#
A "Revenue by branch" table with a data bar on the receita column and a color rule on
margem:
| branch | revenue | margin |
|---|---|---|
| São Paulo | ▇▇▇▇ 250 | 18% (green) |
| Rio de Janeiro | ▇ 90 | 7% (amber) |
| Belo Horizonte | ▇▇ 140 | -2% (red) |
Expected result#
Cells get a color/icon/bar according to the rules; the number stays readable and the pattern jumps out.
Accessibility#
Color alone doesn't communicate to everyone. Combine color + icon (▲▼•) so the information survives in grayscale and for readers with color blindness. The theme already goes through a contrast check (see themes), but very light highlight colors on a light background reduce readability — test it.
Limits and caveats#
- It applies to numeric columns; non-numeric values are ignored by the rule.
- It's formatting of the visual, on top of that visual's snapshot/query — it doesn't change the data or the model.
- The logic of which color each value gets is covered by automated tests.
Related#
Last reviewed: 2026-10-03.