BLOGS BY TOPIC
BLOGS BY AUTHOR
BLOGS BY YEAR
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.
- Updates to Power BI Desktop for August 2017
- Parameters for What-If Analysis
- Live Connection to Power BI Service Data Sources
- Multiple Values for a Matrix can now Appear as Row Headers
- Conditional Formatting of Font Colour (this blog)
- Customising Matrix Subtotals
- More Improvement to Line Charts
- 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:

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:

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:

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!
- Updates to Power BI Desktop for August 2017
- Parameters for What-If Analysis
- Live Connection to Power BI Service Data Sources
- Multiple Values for a Matrix can now Appear as Row Headers
- Conditional Formatting of Font Colour (this blog)
- Customising Matrix Subtotals
- More Improvement to Line Charts
- New Scatter Chart Insights