Column chart conditional formatting

Conditional formatting can be applied to column charts by specifying a measure, such as product margin in the color saturation field well. By default, the value of this measure will drive the saturation of color for each column in the visual. To take further control of the formatting or to apply a conditional formatting rule, the Diverging formatting options under the Data colors card can be modified.

In the following example of a column chart, a product margin percentage measure is used as the Color saturation field (above tooltips) and threshold values have been entered to define the formatting rule:

Diverging Data colors formatting

With the Diverging property enabled this rule associates three colors (red, yellow, and green) with Minimum, Center, and Maximum values of -6.5%,0%, and 6.5%, respectively. This rule will make it easy for users to distinguish the columns, such as fiscal periods or product categories, associated with low, average, and high product margins.

By disabling the Diverging property, a rule can be specified for only a minimum and a maximum value. This can be useful to change the color of a column only when a threshold is reached. In other words, the chart will at most display two distinct colors with one of the colors (for example, red) flagging the exceptions. To implement this rule, simply specify the same value for both minimum and maximum inputs and then associate different colors for each.
..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset
3.137.212.124