Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Use conditional formatting in charts (bar, line, timeline) to highlight individual bars, ranges, scatters, or bubbles.

...

Conditional formatting is available in bar, line, and timeline [1] charts for types: bar, scatter, range, and bubble [2].  

...

Select Conditional formatting [3] for the measure if its type is bar, scatter, range, or bubble

...

Specify one or several rules [4] to detect charts that should have different colors. You can set one or multiple rules, the first matching rule will be used. If no rule is applied, then the default color is used for the chart [5].

There are two ways how to apply those rules [7]: you can set them on the values displayed in the charts or on the value calculated by a custom formula.  Also, there are several ways to define conditions [6]: Range, Exact value, Regular expression, and Top/Bottom. Select one of them. 

...

Range

Specify ranges of values that should have different formatting. Can be used for numeric values, percentagesdates, or file sizes. Both min and max end-point values are included in the range.

...

Bubble chart with applied rules:

...

Using custom formula

By default, the chart measure value is used for selecting the matching rule. In some specific cases, you can override it with a custom calculation formula. Custom calculations use the same MDX expressions as calculated member formulas. You may use an already existing measure as a custom calculation or write the calculation directly in the form.

...