Conditional Formatting in Google Data Studio

Based on the data, you can set the font and background colors used in your charts. For example, if Revenue is greater than 100000, then set the scorecard text color to green.

Conditional formatting only available within 3 charts

1. Scorecards

2. Table

3. Pivot Table

Available Conditions in Google Data Studio

1. Metrics condition: EQUAL TO | NOT EQUAL TO | GREATER THAN | GREATER THAN OR EQUAL TO | LESS THAN | LESS THAN OR EQUAL TO | EMPTY | NOT EMPTY | IS TRUE | IS FALSE | CONTAINS | DOES NOT CONTAIN | STARTS WITH | REGEX

2. Dimensions condition: EQUAL TO | NOT EQUAL TO | EMPTY | NOT EMPTY | CONTAINS | DOES NOT CONTAIN | STARTS WITH | REGEX | IS FALSE | CONTAINS | DOES NOT CONTAIN | STARTS WITH | REGEX

3. Additional conditions available in the Scorecard: IS TRUE | IS FLASE

Single color conditional formatting: Single color conditional formatting lets you apply a specific font color and background to your data. Single color conditions can include:

• Dimensions

• Metrics

• Multiple conditions using AND/OR logic.

Color scale conditional formatting: Color scale conditions let you evaluate a single metric against its percentage or absolute numeric value.

How to select colors?

• Hover over an existing data point and click Add icon to add more data points.

• To remove a data point, hover over it and click the Delete icon.

Single color: Use the color pickers to select the font color and background color to the target values for each condition. You'll see an example appear on the right.

Color scale: The data points determine your color scale's minimum, middle, and maximum values. By default, the new color scale defines 3 data points by percentage with preset colors (red, yellow, green). However, you can base the scale on whole numbers and choose a different color for each data point.

Conditional formatting limitation

• You can have a maximum of 5 data points and a minimum of 2 data points.

• Solid color conditional formatting is currently only available for tables, pivot tables, and scorecards.

• Color scale conditional formatting is currently available for tables and scorecards.

• Conditional formatting on pivot tables that use Expand-Collapse only works if the rule is based on "Any value."

• Dimension-based compound conditions in pivot tables must use the same field in each OR condition.

• Format rules can only use fields currently contained in the chart.

• A maximum of 20 formatting rules can be set per chart.

• Switching between chart visualization types (for example, switching a table to a scorecard) may require you to update conditional formatting rules, depending on the type of chart and the fields used in the rule.