Power BI conditional formatting: let the numbers set the color
Power BI conditional formatting changes how a value looks according to the data behind it. A table cell can turn red below a target, show a bar that matches its size or carry an icon. As a result, readers spot outliers without reading every figure. This guide walks through the options for tables and matrices, the steps to apply them and the limits Microsoft documents.
- Colors, bars and icons
- Rules in four steps
- Documented limits
Last updated
What is Power BI conditional formatting?
A plain table treats every number the same. Conditional formatting breaks that pattern. It ties the look of a cell to a value, so high and low figures stand apart at a glance.
Microsoft documents the feature for Power BI Desktop and the Power BI service. In a table or matrix you can format the cell background, the font color, data bars, icons and web links. You can also combine more than one option in a single column.
The formatting needs something to read. You can base it on a field with numeric values, on color names or hex codes, or on web URLs. So a text column can still change color, provided a suitable field drives it.
Power BI conditional formatting options for tables and matrices
Each option below appears under the Conditional formatting menu of a field, and each one suits a different reading task.
| Option | What the reader sees | Works well for |
|---|---|---|
| Background color | A shaded cell | Heat maps and status bands |
| Font color | Colored text in the cell | Subtle flags on dense tables |
| Data bars | A bar whose length follows the value | Quick size comparison |
| Icons | A symbol beside or in place of the value | Status against a threshold |
| Web URL | The value becomes an active link | Jumping to a related page |
Three format styles for background and font color
The color dialog offers three styles, and the right one depends on how the business thinks about the figure.
Gradient
A color scale runs from the lowest value to the highest. You can also add a middle color, which suits figures that swing around a center point.
Rules
You enter value ranges and give each one a color. For example, green above target, yellow near it and red below.
Field value
A field or measure supplies the color itself as a name or a hex code. Therefore the logic lives in one DAX formula, not in a dialog.
Apply color rules to a table column in four steps
These steps follow the menu path in Microsoft's article, and the same path leads to every other option.
Open the field menu
First select the table or matrix. Then, in the Visualizations pane, select the down-arrow next to the field you want to format.
Choose the format type
Next select Conditional formatting and pick Background color or Font color. A dialog opens with the field name in its title.
Set the style and rules
Then choose Rules as the format style. Enter each value range and assign a color, and select OK to apply.
Check totals and blanks
Finally look at the total row and at empty cells, because rules can apply to totals and subtotals as well.
How do you color a column by its text values?
Many authors expect to color a status column directly, as Excel allows. Power BI works differently. Microsoft states that you cannot color code text values this way. Instead you create a measure that turns each status into a color.
The documented pattern uses the SWITCH function. It maps each status to a color name, such as blue for accepted and red for declined. Then you open the Background color dialog, choose Field value as the format style and point it at that measure.
This approach also scales better than long rule lists. Microsoft notes that a formula is usually faster to create than multiple rules in the dialog. So when the logic grows, move it into DAX.
Which limits of Power BI conditional formatting should authors know?
First, in a matrix the formatting applies to values only. You can format values, totals and subtotals, but not the row or column headers. It also overrides any custom background or font color already on those cells.
Second, the feature needs an aggregation or a measure behind the value. That is why the dialog shows a summarization such as First or Last for a text field. A table without any grouping shows as a single row, and that row does not support the formatting.
Third, printing needs care. Data bars and background colors print properly only when the browser's print settings have background graphics turned on. So test a printed page before you promise one to a board meeting.
Power BI conditional formatting: questions from report authors
Does conditional formatting in Power BI work on charts as well?
Yes. Microsoft notes that the feature is also available for other visual types, including column charts, bar charts, button slicers and cards. The options differ by visual, so check the documentation for the one you use. Tables and matrices still offer the widest range, such as data bars and icons.
How do I remove a format I no longer want?
Open the same field menu in the Visualizations pane. Then select Remove conditional formatting and choose the type to remove. Because each type stands alone, you can drop the icons on a column and still keep its background color or its data bars.
Can I show only the data bar without the number?
Yes. The Data bars dialog has a Show bar only option, and it starts unchecked. When you select it, the cell shows the bar without the value. You can also set minimum and maximum values, the bar colors, the direction and the axis color in that dialog.
Can Power BI conditional formatting use my own icons?
Yes. With the Field value format style, you can point at a column that contains image URLs. Microsoft documents that the address can be an anonymously accessible web URL or an image stored in OneLake. So a team can show brand symbols instead of the built-in sets.
Can Power BI Agency standardize formatting across our reports?
Yes. One of our consultants agrees a small set of color rules with your team and applies them through shared measures, so every report reads the same way. The work happens online in your own Microsoft tenant. Power BI Agency is a division of Sataware Technologies, independent of Microsoft, and replies within 2 hours.
Let's build your first dashboard together.
Tell us what you report on today. A consultant replies within 2 hours with next steps.
Trusted partners
Microsoft Solutions Partner · AWS Partner
Cloud & AI Platforms
Azure SQL, Microsoft Fabric and the data pipelines behind your reports.
AI Business Solutions
Power BI reporting on your Dynamics 365, Business Central and Power Platform data.
Security
Row-level security and Entra ID sign-in on every report and workspace.
Amazon Web Services
Power BI on your AWS data, with connectors for Redshift, Athena and S3.