Conditional Formatting in Looker 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
Scorecards
Table
Pivot Table
Available Conditions in Looker 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
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.
- Background and Border
- Missing Data
- Conditional Formatting
- Chart Header
- Legends
- Reference Lines
- Report Settings
- Data Blending
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
Chart Guide: