Conditional formatting of data in more visualizations

You can conditionally format data with color in more visualizations and set properties to format data which you select with rules.

Previously, conditional formatting with color was available for crosstab, table, and KPI visualizations. For more information, see Highlighting conditionally formatted data with color.

You can use the formatting in the following other visualizations in dashboards, explorations, and stories:
  • Area
  • Bar
  • Bubble
  • Bullet
  • Column
  • Line
  • Pie
  • Point
  • Stacked bar
  • Stacked column
  • Treemap

The following example of a bar visualization shows Quantities by Product types with orange as the conditional color that highlights quantities greater than 2,757,000.

An image of a bar visualization with conditionally highlighted quantities

The following properties of conditional formatting are modified or new:
  • By default, the value of Fill color opacity is set to 100 for the new visualizations.
  • More than three rules can be created to conditionally color measures in KPI visualizations.
  • When you use the conditional formatting in line visualizations, the Show markers property is not available in Properties > Visualization > Chart. You cannot make markers invisible.
  • The conditional color is also applied to measures when you turn on insights.

Note: The following limitations apply:
  • You cannot highlight data elements that are generated by forecasting.
  • You can apply the Conditional color option to single data item at a time.

The following image shows how a bar visualization with conditionally highlighted measures looks when you turn on Insights. Measures greater than 2,757,000 are in orange. Bars of meaningful difference are entirely filled with color. Other bars have only colored borders.

An image of a bar visualization with highlighted measures after you turn on Insights