WiseOwl Training - Established 1992
COVID-19: Choose between our familiar (but now socially distanced) classroom training courses and our excellent new live online courses.
This page has 0 threads   |  Add post
Five star reviews Outstanding course feedback
Average score 9.33 out of 10, based on 8996 reviews
If you found this blog useful and you’d like to say thanks you can click here to make a contribution. Thanks for looking at our blogs!

BLOGS BY TOPIC

BLOGS BY AUTHOR

BLOGS BY YEAR

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