Color themes in Power BI - Cell-by-Cell Formula Trace

Sample Data

Sample sales data by region to visualize with color themes.

Cell	Value
A1	Sales
A2	100
A3	200
A4	150
B1	Region
B2	North
B3	South
B4	East

Formula Trace

Theme colors applied to bar chart by Region

Step 1: Select color theme 'Sunset'

Step 2: Assign colors to regions in order: North, South, East

Step 3: Apply colors to bar chart bars representing sales

Cell Reference Map

    A       B
1 | Sales | Region
2 |  100  | North  --> Color #FF5733
3 |  200  | South  --> Color #FFC300
4 |  150  | East   --> Color #DAF7A6

Data cells A2:A4 provide sales values; B2:B4 provide region categories linked to theme colors.

Result

North

↓

South

↓

East

Bar chart shows sales by region with bars colored using the 'Sunset' theme colors for clear visual grouping.

Sheet Trace Quiz - 3 Questions

Which color is assigned to the 'South' region in the 'Sunset' theme?

A #DAF7A6 (light green)

B #FFC300 (yellow)

C #FF5733 (red-orange)

D #000000 (black)

Key Result

Color themes assign a set palette of colors to data categories in order for consistent visual styling.