Rules for Applying Conditional Formats in Graphs

This is a short description.

The following rules apply for building and using conditions in graphs:

• Conditions can be created only from columns that are being used by the graph.

• When format conditions conflict with each other, conflicting conditions are prioritized in the following order:

  1. Conditional formatting on attributes

  2. Conditional formatting on measures

  3. Style formatting based on the positions of graph elements

• When a user drills on a graph that has conditional formatting applied, the following rules apply:

  • A conditional format based on measures is not carried to the next level. (It does not make sense to carry the conditional format to a different level; for example if, in a geographic hierarchy, from Region to City.

  • A conditional format based on attributes is carried to the next graph if it has not been drilled on.

    For example, if you had the conditional format "Lemonade=Blue" and only drill on years, then "Lemonade=Blue" stays in place.

Graph Exceptions for Conditional Formatting on Columns

Graph Type	Exception
Line Line-Bar Radar Time Series Line	Only symbol formatting is allowed for the line.
Pareto	Formatting is applied only to the bars, not to the Pareto line.