Changes made in August 2017 to Power BI Desktop
Part five of an eight-part series of blogs

A quiet month, after the frenetic activity of the July update, sees lots of small changes to matrices, tables and charts, but no single big update.

  1. Updates to Power BI Desktop for August 2017
  2. Parameters for What-If Analysis
  3. Live Connection to Power BI Service Data Sources
  4. Multiple Values for a Matrix can now Appear as Row Headers
  5. Conditional Formatting of Font Colour (this blog)
  6. Customising Matrix Subtotals
  7. More Improvement to Line Charts
  8. New Scatter Chart Insights

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

Posted by Andy Brown on 14 August 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 Font Colour

This probably won't change many people's lives!  You can now apply conditional formatting to both the foreground and background colour of table rows:

Conditional formatting example

It's a bit hard to see, but the larger numbers are in a darker font.

 

To get effects like this, right-click on the numerical field that you want to conditionally format:

Font colour scales

The conditional formatting submenu has got a new option on it.

You can then set conditional formatting of the foreground colour of text in exactly the same way as you currently set background colour conditional formatting:

Foreground colour conditional formattting

Here the higher the value (at least up to a maximum we've set of 5,000), the darker the red colour used for the font.

I don't think I'd have made this change high-priority, but it was probably an easy one to make! 

  1. Updates to Power BI Desktop for August 2017
  2. Parameters for What-If Analysis
  3. Live Connection to Power BI Service Data Sources
  4. Multiple Values for a Matrix can now Appear as Row Headers
  5. Conditional Formatting of Font Colour (this blog)
  6. Customising Matrix Subtotals
  7. More Improvement to Line Charts
  8. New Scatter Chart Insights
This blog has 0 threads Add post