COVID-19: Choose between our familiar (but now socially distanced) classroom training courses and our excellent new live online courses.
New features introduced in the July 2019 update of Power BI
Part four of a seven-part series of blogs

There are big changes to conditional formatting this month (you can display icons, and use percent-based thresholds), but the biggest change of all is the release - finally - of the new filter pane.

  1. Changes introduced in the July 2019 Power BI update
  2. The new fllter pane
  3. Adding icons into the table and matrix visuals
  4. Conditional formatting using percentages (this blog)
  5. Aggregation tables
  6. Little updates and changes
  7. Features waiting in preview

For a cumulative list of all of the updates to Power BI Desktop in the last few years see this blog, or have a look at the Power BI courses that we run.

Posted by Sam Lowrie on 02 August 2019

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 using percentages

Conditional formatting is a great tool for any report builder, but up till now only fixed numbers could be used:

Power BI Percent conditional formatting

The only other option would be to write DAX to perform other calculations.

Released at the same time as the new icon feature there is now the option to set conditional formatting using thresholds based on perecentages:

Power BI Percent

These work with formatting on icons, font colour, background colour and most visual colour options.

Now it is just a case of selecting the percentages you consider bad, mild and good:

Power BI Percent

The lower and upper limits when using Percent must be entered.

An interesting side effect has occurred with this new feature when using the Maximum option for numbers as in the image above:

Power BI Percent

The Maximum changes to 100 and the Number to Percent.

A nice little feature which will save the need to constantly define what the bandings for colouring are.

This blog has 0 threads Add post