Skip to main content
Adaptive Insights
Knowledge and Support - Adaptive Insights

Conditional Formatting for Charts

Provides an overview of conditional formatting in the Discovery new user interface. Conditional formatting draws attention in a chart to exceptions, such as a drop in inventory or above average sales.

You can apply conditional formatting to all chart types, except waterfall charts. Use the Appearance Settings tab to define how to format data that meet certain conditions. Conditional formatting is rule-based that evaluates to true or false. If true, the condition is met and the data is conditionally formatted in the color specified. Rules must reference a data series in the chart.

Suppose you want to highlight good liquidity in a chart when the quick ratio is higher than or equal to 19. You can create an expression: [quick Ratio] >= 19 to evaluate true or false. If true, the data point is formatted in green. The conditional formatting rule and chart view might look like this:

Comparison Expression Evaluates if Quick Ratio is Greater Than or Equal To 19

Display Styles

Charts display data as a numeric value or graphically such a bar or column. The display style for a conditionally formatted data point will vary based on the chart type.

Charts with a Numeric Display Style

Conditional formatting is applied to the numeric value on these charts:

  • Crosstab
  • KPI
  • Scorecard

For example, this KPI is highlighted in pink indicating that 4.6 million in revenue falls below expectations:

Conditional Formatting of  Numeric Values on a KPI

Charts with a Graphic Display Style

Conditional formatting is applied to the graphical representation of data to these charts:

  • Area and Line
  • Bar and Column
  • Doughnut and Pie
  • Funnel and Pyramid
  • Gauge and Meter

Doughnut charts conditionally format slices and meter charts conditionally format the meter needle in red when revenue falls below expectations:

Doughnut Chart with Slices in Red and Meter Needle in Red Indicates that Revenue is Below Expectations

Conditional Formatting Rule Order

You can create many conditional formatting rules in a chart. These rules are evaluated from the bottom up. The order of rules matter if you have rules that evaluate true on the same data point. The order of the rule determines the conditional formatting to apply.

You can reorder rules by dragging Handler Iconthe handler icon to the new position.

To get a more predictable outcome, use comparison operators to establish boundaries. Arrange the rules in the order you want these rules to be evaluated.

Create a Conditional Formatting Rule

You can create a conditional formatting rule on new or existing charts. 

  1. Create a chart or edit a chart.
  2. Click Appearance Settings Tab in the right panel to open the Appearance Settings tab. Expand the Conditional Formatting section.

Conditional Formatting UI

  1. Click Add rule. The Conditional Formatting dialog displays.
  2. Define the rule:
    • Provide a brief description, such as Good Liquidity.
    • Build the expression. Click Help Icon for syntax rules and list of operators and functions.
      Example: [Quick Ratio] >= 19, where Quick Ratio is the name of a data series in the chart.
    • Pick the highlight color to format data points when the condition is true.
    • Choose the series on which to evaluate the rule.
  3. Click Save.

Edit a Conditional Formatting Rule

You can edit any conditional formatting rule. Hover over the rule. Click More Icon to open the more menu and choose Edit.

Conditional Formatting Rule With More Icon

The Conditional Formatting dialog displays. Edit the rule and save. The change is reflected in the chart.

Delete a Condition Formatting Rule

You can delete any conditional formatting rule. Hover over the rule. Click More Icon to open the more menu and choose Delete. A confirmation message displays. Click OK to delete.

  • Was this article helpful?