The drill-through action is out of preview, and enhanced

I blogged in March about the drill-through button introduced into Power BI:

The idea is that instead of asking your user to guess that they should right-click to drill-through to show sales by (here) the chosen family, you can create a button to let them do this.

A clickable button might look like this:

You can only click on the button when you have a single family selected in the chart.

Microsoft have now made a number of properties of this button dynamic:

You can, for example, set the destination page to depend on what you currently have selected.

The rest of this page gives one case study of how you might use this.

The case study

For our example, suppose that you want your user to be able to drill-down to one of two pages:

Your user should be able to choose which page they want to drill through to before clicking on the Show sales button.

To get this to work you need to create a table of destination choices, link this to a slicer and then set the button action to the destination page chosen.

Creating the table of destinations

First choose to create a table containing each page that a user could drill through to:

The page names must match exactly the pages in your report.

The entries correspond to these hidden pages:

Each of the drill-through pages will appear only on demand.

Creating the slicer

Now create a slicer to allow a user to choose which page to drill-through to:

Here I've made my slicer horizontal and given it a title.

The field well for the slicer contains the Destination page field:

A user can choose any of the destination page choices you've typed into your table.

Make sure that a user can select one, and one only destination:

Set the Single select property, so that a user has to choose one destination and one destination only.

Attaching an action to your button

Now create a button to drill-through to another page:

Our drill-through button.

Set the action to drill-through (obviously):

When a user clicks on the button, it should drill-through to another page.

Click on the fx icon to set the destination page to be an expression:

Click on this icon to set the destination page.

Set the destination page to be the one chosen in the slicer:

Choose the Destination page field from the slicer. You'll then be asked to choose the statistic for this field (First or Last) - because a user can only ever select one value, it doesn't matter which of these you choose.

Testing your system

Provided a user has chosen a region and a destination, they should now be able to use your button to go to the appropiate page of your report:

The tooltip should automatically reflect the destination page choice you made.