The main new features for BI workers in the November 2016 Power BI update
Part three of a seven-part series of blogs

A summary of the new features in the November 2016 Power BI Update, omitting things which are still only in preview.

  1. Power BI Desktop - November 2016 update
  2. Dropdown slicers - the new list option
  3. Conditional formatting now available for matrices (this blog)
  4. Formatting table and matrix columns
  5. Changing the colour of axis titles and labels
  6. Prevent hierarchy axis label concatenation
  7. Forecasting now extended to Power BI Service

You can see a list of all updates going back to November 2016 (this update) here.

Posted by Andy Brown on 19 December 2016

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 now available for matrices

You could already do this for tables, but now it works for matrices too:

Heat map

Here I've coloured the matrix cells according to the total quantity shown in each.

To get this to work, click on the drop arrow next to the Values field in the field well:

Conditional formatting menu

Here we're showing the total quantity for each row/column combination, so click on the arrow to the right of Quantity and choose to change its conditional formatting.


You can now set the formatting you want to use:

Formatting dialog box

Tick the Diverging box shown above to include an additional colour for the middle value.

A welcome new feature!

This blog has 0 threads Add post