Skip to content

Automatic translation — the Portuguese version is the reference. View in Portuguese

Updated on 2026-10-03

Conditional formatting

Color rules per column, heat scale and data bars inside the cell — visual highlighting in tables and matrices.

On this page (13)

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 %"):

OrderRuleColorIcon
1< 0red▼
2< 10amber•
3>= 10green▲

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#

  1. 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).

  2. Open the section

    In the visual pane, Format tab, open Conditional formatting. The section says how many rules already exist.

  3. 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.

  4. Set the type

    Choose rules (color/icon by range), heat scale or data bar, on the numeric column you want to highlight.

  5. Order the rules

    If you use rules, put the most specific condition at the top — the first one that matches wins.

  6. 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."

Conditional formatting window open on top of the visual pane

Example (synthetic)#

A "Revenue by branch" table with a data bar on the receita column and a color rule on margem:

branchrevenuemargin
São Paulo▇▇▇▇ 25018% (green)
Rio de Janeiro▇ 907% (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.

Related links