BLOGS BY TOPIC
BLOGS BY AUTHOR
BLOGS BY YEAR
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.
- Changes introduced in the July 2019 Power BI update
- The new fllter pane
- Adding icons into the table and matrix visuals
- Conditional formatting using percentages (this blog)
- Aggregation tables
- Little updates and changes
- Features waiting in preview
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:
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:
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:
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:
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.