A summary of new features added to Power BI Desktop in the May 2018 update
Part three of a six-part series of blogs

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.

  1. Power BI Desktop - May 2018 update new features
  2. Conditional formatting by different fields
  3. Drill-through uses all field values and works with measures (this blog)
  4. Various improvements to charts
  5. Improvements to slicer syncing
  6. 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.

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:

Target page 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:

Adding region to drill-through

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:

Drill-through to target

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:

Keeping filters

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: 

Drill-through with slicer

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: 

Filtered data

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:

Temporary filters

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! 

This blog has 0 threads Add post