Coloring Cards Based on Threshold Values

With overview pages, column chart cards can be semantically colored based on threshold values.

The threshold values used to semantically color column charts come from the data point annotation that is associated with the measure used in the analytic card. It's recommended to only use one measure in the chart if you intend to use this feature.

When you color the chart card, the threshold value that influences the semantic color would also be displayed in the legend; however, in instances where you have more than one measure, then the chart legend would only show the values "Good", "Bad" and "Neutral". For example, a measure can be linked with a data point as follows, if the following two conditions are met::

This data point should have a value which provides the improvement direction (this typically depicts whether we are dealing with a maximizing measure where higher value of measure is better, minimizing measure where lesser value of measure is better or a target measure where the measure value is preferred within a certain range).
It's also required to have at least one of the threshold values based on the examples below.

Note

It's recommended to configure only one measure in the chart if you want to use semantic coloring. If more than one measure is used and all the measures satisfy the above two conditions, then the chart would still be colored semantically with each measure colored based on its own threshold values. The legends, however, won't be very meaningful.

In case more than one measure is used and some of the measures don't satisfy the required conditions, those measures will be colored black and the measures that do satisfy the conditions will be svaluesemantically colored based on the threshold values.

Examples

The following are examples of measures:

Negative

Critical

Positive

Critical

Negative

Measure Type	From	To	Measure Value
Target	Negative	Critical	>= ThresholdValues.DeviationRangeLowValue Critical
Target	Critical	Positive	>= ThresholdValues.ToleranceRangeLowValue
Target	Positive	Critical	> ThresholdValues.ToleranceRangeHighValue
Target	Critical	Negative	> ThresholdValues.DeviationRangeHighValue
Maximizing	Negative	Critical	>= ThresholdValues.DeviationRangeLowValue
Maximizing	Critical	Positive	>= ThresholdValues.ToleranceRangeLowValue
Minimizing	Positive	Critical	> ThresholdValues.ToleranceRangeHighValue
Minimizing	Critical	Negative	> ThresholdValues.DeviationRangeHighValue


Semantic coloring with target KPIs	Semantic coloring with maximizing KPIs