Conditional formatting in tables in Power BI - Dashboard Guide

Dashboard Mode - Conditional formatting in tables

Goal

Show which sales amounts are high or low by coloring the sales values in the table. This helps quickly see good and bad sales.

Sample Data

Region	Salesperson	Sales Amount
North	Alice	1200
South	Bob	800
East	Charlie	1500
West	Diana	600
North	Eva	2000
South	Frank	400
East	Grace	1700

Dashboard Components

• Table Visual: Shows Region, Salesperson, and Sales Amount columns.
• Conditional Formatting Rules on Sales Amount:
  • Sales >= 1500: Green fill color (good sales)
  • Sales between 800 and 1499: Yellow fill color (average sales)
  • Sales < 800: Red fill color (low sales)
  This uses Power BI's conditional formatting feature on the Sales Amount column.

Dashboard Layout

+-----------------------------+
|        Sales Table          |
| +-------------------------+ |
| | Region | Salesperson | Sales Amount | |
| |--------|-------------|--------------| |
| | North  | Alice       | 1200 (Yellow) | |
| | South  | Bob         | 800  (Yellow) | |
| | East   | Charlie     | 1500 (Green)  | |
| | West   | Diana       | 600  (Red)    | |
| | North  | Eva         | 2000 (Green)  | |
| | South  | Frank       | 400  (Red)    | |
| | East   | Grace       | 1700 (Green)  | |
| +-------------------------+ |
+-----------------------------+

Interactivity

You can add a slicer for Region. When you select a region, the table updates to show only salespeople from that region. The conditional formatting colors update automatically based on the visible sales amounts.

Self Check

If you add a filter to show only the South region, which sales amounts will be visible and what colors will they have?

Answer: Sales amounts 800 (yellow) for Bob and 400 (red) for Frank will show.

Key Result

A sales table with conditional colors showing high, average, and low sales amounts by region and salesperson.