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
- Drill-through uses all field values and works with measures (this blog)
- Various improvements to charts
- Improvements to slicer syncing
- Features still in preview as of May 2018
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.
Drill-through uses all field values and works with measures
This allows you to keep current filter settings when using drill-through. To show how it works, let's first have a quick reminder of what drill-through is and does.
An existing drill-through scenario
Suppose you have a report containing two pages: Source and Target. The target page contains a matrix:
The matrix shows total sales by region and environment.
I've also dragged the RegionName field onto the Drill-through area of the filters for the target page:
This means that I can now drill through to this page (as shown below).
So i can now drill-through to show sales for any given region:
I can right-click on any region in a visual to show sales for that region on the target page.
The big question is: what happens to any other filters on the source page?
The answer prior to the May update of Power BI Desktop is that any other filters would not carry through to the target page (and this is actually still the default behaviour).
Taking filters on drill-through
When setting up a drill-through field, you can now specify that any filters will be taken into account:
This new setting allows you to keep filters when you drill through.
So let's say that you drill through on the North-West region for the report page shown:
Note that here I've selected Shopping Park as my centre type. The question is: will the target page show sales just for shopping parks?
The target page now shows sales for the North-West region and for Shopping Park centre types:
Don't believe me? Have a look at the filters applying to the page, as shown below.
If you have a look at the filters applied to this page, you'll see this:
The filter in italics at the bottom is a temporary filter which is carried through from the source page.
I'm not quite sure which behaviour I prefer for my drill-throughs - keeping filters or ignoring them - but at least you now have a choice!