The April 2019 update to Power BI has many good features, as this blog explains
Part five of a nine-part series of blogs

The April 2019 update to Power BI introduces a new concept: the ability to make the value of a property dynamic. Other welcome new changes include M Intellisense, data profiling in query editor and cross-report drill-down.

  1. The April 2019 Update to Power BI Desktop
  2. Conditional titles for visuals and conditional URLs
  3. Intellisense in the M Query Editor Language
  4. Data profiling in Query Editor
  5. Cross-report drill-through (this blog)
  6. Fuzzy merging
  7. Power BI Dataflows
  8. Other changes in the April 2019 update
  9. Power BI features waiting in preview, as of April 2019

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 Andy Brown on 18 April 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.

Cross-report drill-through

So you've been able to drill through to a different page of the same report for some time now.  The idea behind this feature is that you set up a page to show the details for a particular dimension value (let's say, for an environment):

Hidden page

This hidden page will show analysis of the different habitats for a chosen environment (be it air, land or water).

 

You can then drag a field onto the DRILLTHROUGH property section of a report:

Drill-through properties

We're going to let people see more details for any selected environment.

 

You can then right-click and drill through in another page of the same report to see more details for any given environment:

Drill-through menu

What the drill-through menu looks like.

So far, so good.  What the new feature allows you to do is to drill through to a page in a different report:

Cross-report button

The Cross-report option is pretty obvious and easy to use - but what does it do?

 
 

Note that Microsoft recommend that you also turn the Keep all filters option off - as above - when using cross-report drilldown. 

To get this feature to work, you also have to go into Power BI options:

File Options

Choose to go to the Options menu in Power BI.

 

You then need to tick the box shown below to say that you want your reports to interact with each other in this way:

Tick the box

Enable the option shown!

Note that you have to do this separately for both reports (thanks, Sam).  I spent ages trying to find out why the feature wasn't working, when I'd only ticked the above box for one report.

When you publish the reports, here's what you should see in Power BI Service:

Published report drill-down

What you should see in Power BI Service, provided of course that you've published both reports to the same workspace.

There are a lot of hoops to jump through to get a small improvement!  Or am I being churlish?

This blog has 0 threads Add post