A summary of new features added to Power BI Desktop in the May 2018 update
Part two of a six-part series of blogs

New features introduced into Power BI Desktop in this update include conditional formatting by different fields, the inclusion of filters in drill-through and minor improvements to line and funnel charts.

  1. Power BI Desktop - May 2018 update new features
  2. Conditional formatting by different fields (this blog)
  3. Drill-through uses all field values and works with measures
  4. Various improvements to charts
  5. Improvements to slicer syncing
  6. Features still in preview as of May 2018

For a cumulative list of all of the updates to Power BI Desktop in the last few year or two, see this blog.  Our two-day Power BI Desktop course always uses the latest version of the software.

Posted by Andy Brown on 14 May 2018

You need a minimum screen resolution of about 700 pixels width to see our blogs. This is because they contain diagrams and tables which would not be viewable easily on a mobile phone or small laptop. Please use a larger tablet, notebook or desktop computer, or change your screen resolution settings.

Conditional formatting by different fields

This is the best innovation this month - it allows you to create effects like this:

Conditional formatting by field

The darker the region, the higher the sales for it (this table colours the region's name according to the value of a different field: the total quantity sold).

 

To get this to work, it's important to first select the field you want to format, and not the field whose values determine the formatting to use - as I've just discovered!

To produce the table above, for example, choose to apply conditional formatting to the Region field:

Region name

Click on the drop arrow in the field well next to the field whose appearance will change (in this case, the region field).

 

Choose to apply conditional formatting:

Conditional formatting menu

Select to change either the background or foreground colour.

Power BI Desktop selects the Apply color to field for you, and you can't change this:

Apply color to field

Here we're applying colours to the Region field.

You can now choose the value to use for the conditions:

Choosing field to use

On the right-hand side of the same dialog box, choose the field whose value should determine the colours to use, and which function you want for it (summing, counting, averaging, etc).

The rest of conditional formatting is unchanged. 

This blog has 0 threads Add post