BLOGS BY TOPIC
BLOGS BY AUTHOR
BLOGS BY YEAR
New features introduced into Power BI Desktop in this update include conditional formatting by different fields, the inclusion of filters in drill-through and minor improvements to line and funnel charts.
- Power BI Desktop - May 2018 update new features
- Conditional formatting by different fields (this blog)
- Drill-through uses all field values and works with measures
- Various improvements to charts
- Improvements to slicer syncing
- Features still in preview as of May 2018
For a cumulative list of all of the updates to Power BI Desktop in the last few year or two, see this blog. Our two-day Power BI Desktop course always uses the latest version of the software.
Posted by Andy Brown on 14 May 2018
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 by different fields
This is the best innovation this month - it allows you to create effects like this:
The darker the region, the higher the sales for it (this table colours the region's name according to the value of a different field: the total quantity sold).
To get this to work, it's important to first select the field you want to format, and not the field whose values determine the formatting to use - as I've just discovered!
To produce the table above, for example, choose to apply conditional formatting to the Region field:
Click on the drop arrow in the field well next to the field whose appearance will change (in this case, the region field).
Choose to apply conditional formatting:
Select to change either the background or foreground colour.
Power BI Desktop selects the Apply color to field for you, and you can't change this:
Here we're applying colours to the Region field.
You can now choose the value to use for the conditions:
On the right-hand side of the same dialog box, choose the field whose value should determine the colours to use, and which function you want for it (summing, counting, averaging, etc).
The rest of conditional formatting is unchanged.
- Power BI Desktop - May 2018 update new features
- Conditional formatting by different fields (this blog)
- Drill-through uses all field values and works with measures
- Various improvements to charts
- Improvements to slicer syncing
- Features still in preview as of May 2018