Browse 534 attributed reviews, viewable separately for our classroom and online training
Power BI Desktop - January 2017 update
Part three of a five-part series of blogs

A summary of the (small) changes in Microsoft's January 2017 Power BI Desktop update.

  1. Power BI Desktop - January 2017 update
  2. Word Wrap in Column Headings
  3. Conditional Formatting of Blank Values in a Matrix or Table (this blog)
  4. Summarising to show earliest/latest dates, or first/last text
  5. Creating Phone Optimised Reports

For a cumulative list of all of the updates to Power BI Desktop since November 2016 see this blog, or have a look at the Power BI courses that we run.

Posted by Andy Brown on 08 February 2017

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 of Blank Values in a Matrix or Table

Suppose you have a matrix showing total sales:

Sales by centre type and family

The matrix looks a bit silly, as the blank values are coloured.

To change conditional formatting of blanks, first go into conditional formatting for the matrix's values:

Conditional formatting

Right-click on a matrix or table's Values field, and choose this option.


You can now choose one of 3 options for how blanks will look:

The three blank formatting options

Display blanks as they are, as if they contained zeros or in a specific colour.

Here's what the Don't format option would look like for our example:

Don't format option

The Don't format option ... doesn't format the blanks!


For the Specific color option, you can choose any colour:

Specific color

Try to make sure it matches, though!


Another tiny step towards perfection ...


This blog has 0 threads Add post