Back to ComponentsInteractive example
Related
Analytics & formattingNative Power BIRecommendedLive example
Conditional Formatting
Apply data-driven font, background, icons, bars or property formatting.
Revenue by store
Click a row to cross-filter, click a header to sort
8 rows
| vs Budget | ||||
|---|---|---|---|---|
| Eindhoven | €1.7M | €1.7M | €411k | ▼ -1.1% |
| Groningen | €1.2M | €1.2M | €302k | ▼ -1.9% |
| Amersfoort | €1.2M | €1.2M | €291k | ▼ -0.5% |
| Rotterdam | €986k | €999k | €248k | ▼ -1.3% |
| Den Haag | €911k | €923k | €227k | ▼ -1.3% |
| Utrecht | €900k | €906k | €223k | ▼ -0.7% |
| Arnhem | €899k | €903k | €225k | ▼ -0.4% |
| Nijmegen | €679k | €687k | €170k | ▼ -1.1% |
| Total | €8.4M | €8.5M | €2.1M | -1.0% |
Simulated behaviour on the shared fictional retail dataset. Native mechanism: Yes.
Best for
Exception detection, threshold/status cues, compact in-cell magnitude.
Avoid when
Coloring every value or creating a traffic-light wall.
Typical data
Relevant recovered tags: conditional formatting, icons, data bars, rules
Usage
Exception detection, threshold/status cues, compact in-cell magnitude.
Power BI limitation
Support varies by visual/property.