COVID-19: Choose between our familiar (but now socially distanced) classroom training courses and our excellent new live online courses.
What's new in the May 2020 Power BI update
Part six of a six-part series of blogs

The May 2020 update is a good one! The decomposition tree is a seriously good new visual, drop shadows are a nice idea well-implemented, and there are lots of improvements to the way buttons look and work.

  1. New features introduced in the May 2020 Power BI Update
  2. Visuals can now have drop shadows
  3. Buttons can have fill images
  4. The new Decomposition Tree visual
  5. Improvements to page navigation buttons
  6. The drill-through action is out of preview, and enhanced (this blog)

We've been creating our idiosyncratic monthly blogs on Power BI updates since November 2016, and also deliver online and classroom Power BI courses.

Posted by Andy Brown on 24 May 2020

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.

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

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

Drilling through

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:

Clickable drill-through

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:

Dynamic button properties

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:

Choice of 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:

Destination pages

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

 

The entries correspond to these hidden pages:

Two drill-through 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:

Slicer of choices

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

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

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:

Destination single-select

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:

Drill-through button

Our drill-through button.

 

Set the action to drill-through (obviously):

Drill-through action

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:

Destination page expression

Click on this icon to set the destination page.

 

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

Choosing field for page

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 working button

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

All very clever!  Unfortunately as the ability to improve the user's drill-through experience goes up, so too does the Power BI knowledge required to make this happen.

This blog has 0 threads Add post