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:
Conditional formatting on attributes
Conditional formatting on measures
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. |