WiseOwl Training - Established 1992 Wise Owl Training

Established May 1992
30 years in business
Wise Owl Training
30 years in business
See 525 reviews 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