pbi_add_conditional_formatting
Apply data bars, color scales, or icon sets to a column in a Power BI table or matrix visual for enhanced data visualization.
Instructions
Add table / matrix conditional formatting (data bar, colour scale, icon set).
Power BI stores conditional formatting on table-style visuals under
singleVisual.objects.values (or columnFormatting on older
builds), keyed by a queryRef that matches the column / measure
bound to the visual's Values role. We write the canonical shape
Power BI Desktop emits in current builds.
Parameters
column_name:
The display name (Property) of the measure / column inside the
Values projection. Matched case-insensitively against the
prototypeQuery Select entries.
format_type:
One of dataBar, colorScale, iconSet.
min_color, mid_color, max_color:
Colour scale endpoints (and optional midpoint). Hex strings.
bar_color:
Data bar fill colour.
icon_set:
One of threeArrows, threeArrowsGray, threeTrafficLights,
threeSymbols, threeFlags, fiveArrows.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| page | Yes | ||
| icon_set | No | threeArrows | |
| bar_color | No | #4472C4 | |
| max_color | No | #00FF00 | |
| mid_color | No | ||
| min_color | No | #FF0000 | |
| visual_id | Yes | ||
| column_name | Yes | ||
| format_type | Yes | ||
| extract_folder | Yes |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |