Conditional formatting in tables in Power BI - Step-by-Step Guide

Introduction

Conditional formatting helps you highlight important data in your tables by changing colors or styles based on values. It makes it easier to spot trends or issues without reading every number.

When you want to highlight sales figures above a target in a sales report

When you need to show negative profit values in red to catch attention

When you want to color-code customer satisfaction scores from low to high

When you want to visually separate high and low inventory levels in a stock table

When you want to apply different background colors to rows based on a category

Steps

Step 1: Select the table visual

- Report canvas

The table visual is active and ready for formatting

Step 2: Click the dropdown arrow next to the field name you want to format

- Fields pane inside the table visual

A menu with formatting options appears

Step 3: Select 'Conditional formatting' from the menu

- Field dropdown menu

The conditional formatting options panel opens

Step 4: Choose the type of formatting (Background color, Font color, Data bars, Icons)

- Conditional formatting panel

Options for the chosen formatting type appear

Step 5: Set the rules or color scale based on values or rules

- Conditional formatting panel

Preview of colors or icons appears on the table cells

Step 6: Click 'OK' to apply the formatting

- Conditional formatting panel

The table updates to show the conditional formatting visually

Before vs After

Before

Table shows sales numbers in plain black text with no color differences

After

Sales numbers above target are green, below target are red, making it easy to see performance

Settings Reference

Format by

📍 Conditional formatting panel

Choose how to define the formatting: by gradient colors, specific rules, or another field's value

Default: Color scale

Minimum and Maximum colors

📍 Color scale settings in Conditional formatting panel

Set the colors for the lowest and highest values in the data range

Default: Green to red gradient

Rules

📍 Rules settings in Conditional formatting panel

Define specific conditions to apply colors or icons

Default: No rules

Apply to

📍 Conditional formatting panel

Choose whether to format just data cells or also totals

Default: Values only

Common Mistakes

Applying conditional formatting to the wrong field

The formatting will not reflect the intended data and can confuse viewers

Always select the exact field column in the table where you want the formatting to appear

Using conflicting color scales that are hard to interpret

Colors may confuse users if they do not follow a logical order or contrast

Use intuitive color gradients like green to red or blue to white for clarity

Not clicking OK to apply changes

Formatting changes will not be saved or visible on the table

Always confirm by clicking OK after setting rules or colors

Summary

Conditional formatting highlights important data in tables using colors or icons.

You set rules or color scales on specific fields inside the table visual.

Remember to select the correct field and confirm changes to see the effect.