BLOGS BY TOPIC▼
BLOGS BY AUTHOR▼
BLOGS BY YEAR▼
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.
- New features introduced in the May 2020 Power BI Update
- Visuals can now have drop shadows
- Buttons can have fill images
- The new Decomposition Tree visual
- Improvements to page navigation buttons
- 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:

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.
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.
- New features introduced in the May 2020 Power BI Update
- Visuals can now have drop shadows
- Buttons can have fill images
- The new Decomposition Tree visual
- Improvements to page navigation buttons
- The drill-through action is out of preview, and enhanced (this blog)