Conditional colours now apply to charts too

So the Color Saturation bucket has gone the way of the dodo, and been replaced by conditional formatting:

Remember this?  Microsoft have removed Color Saturation for charts, and instead enabled the much more powerful conditional formatting (which has been possible for tables and matrices for some time).

Applying conditional formatting

To see how this works, suppose that you want to colour the bars of this simple chart according to how many goods were sold:

The 2017 bar should be the most colourful!

You can access conditional formatting from the Data colors formatting tools category:

Expand the Data colors category, then click on Advanced controls as shown.

You can then choose one of the 3 types of formatting which have been available for tables and matrices for a while now:

See below for an example of each of these options.

Colour scales

The Color scale option allows you to set a minimum and maximum colour, and have Power BI colour chart bars, columns, slices or bubbles automatically:

Here our colours will go from light to dark brown.

Here's what this chart would show:

As expected, the 2017 column is the darkest.

Colouring by rules

Instead of relying on Power BI to set colours, you can control the colour thresholds by creating rules:

The colours are applied in 3 bands: 0 to10000, 10000 to 15000, and 15000+.

Here's what this would show for our example - eventually:

The 2017 column is again the darkest.

Using field values for colours

This method of colouring works when you have a column specifying how any data should be coloured:

Here we'll colour centre types using what i like to call the Teletubbie palette.

Initially let's suppose we have a tree map showing average price by centre type:

Initially Power BI uses default colours .

Suppose we now apply this colour formatting:

We'll colour each part of the chart using the value of the Colour column.

Here are the regrettable consequences:

The map parts are coloured as requested!