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
Available Conditions in Google Data Studio
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
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
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:
How to select colors?
Hover over an existing data point and click Add icon to add more data points.
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.
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.
Enjoy reading the guide? I have explained every chart available in the new Data Studio Book here. Visual explanations for graphs configurations, style, format, and recommendations. So you can also see how the final result will look and why one design is better than others for the same chart.
- Background and Border
- Missing Data
- Conditional Formatting
- Chart Header
- Reference Lines
- Report Settings
Most Used Features:
- Report Sharing
- Manual Publishing
- Version History
- Embed a Report
- Get a link to your report
- Schedule Email Delivery
- Download as PDF
- Interface Menu & Features
- Most Used Terms
- Keyboard Shortcuts
- Theme and Layout