Read our blogs, tips and tutorials
Try our exercises or test your skills
Watch our tutorial videos or shorts
Take a self-paced course
Read our recent newsletters
License our courseware
Book expert consultancy
Buy our publications
Get help in using our site
551 attributed reviews in the last 3 years
Refreshingly small course sizes
Outstandingly good courseware
Whizzy online classrooms
Wise Owl trainers only (no freelancers)
Almost no cancellations
We have genuine integrity
We invoice after training
Review 30+ years of Wise Owl
View our top 100 clients
Search our website
We also send out useful tips in a monthly email newsletter ...
Power BI Drill through with multiple categories |
---|
A method for using Drill through in Power BI with multiple categories. |
Drill through in Power BI is a fantastic bit of functionality, allowing you to carry forward a category from one page to another where it is used to filter that page. A very common question on courses is whether you can select multiple categories on the source page to drill through to the destination page. The answer to this is a resounding NO!
Drill through available with 1 category selected on the left and not available with 2 categories selected on the right.
A method does exist that will allow multiple categories to be used for drill through with a different approach.
A column chart with film Certificates showing Sum of Oscar Wins and a card with Sum of Oscars.
The above page is my source and I'm going to show how you can select multiple film certificates for drill through.
Usually you would add the category field from the source page, Certificate in this case, to the Drill through bucket in the destination page. Instead, I've added the value field, Oscar Wins, from the source page to the Drill through bucket in the destination page. Note that the Allow drill through when option has automatically been set to Summarized rather than Used as category:
Destination page with Oscar Wins added to the Drill through bucket.
The secret to this method is the fact that Keep all filters is set to On. Any filters applied on the source page will be carried forward to the destination page during drill through.
I've selected 2 categories in the chart, but I'm using the card to activate the Drill through.
The chart interacts with the card and filters it for the selected certificates. The drill through was set to Keep all filters so this is carried forward to the destination page.
The 2 categories from the source page have been carried on to the destination page.
So that's how you can drill through on multiple categories.
Some other pages relevant to the above blog include:
Kingsmoor House
Railway Street
GLOSSOP
SK13 2AA
Landmark Offices
99 Bishopsgate
LONDON
EC2M 3XD
Holiday Inn
25 Aytoun Street
MANCHESTER
M1 3AE
© Wise Owl Business Solutions Ltd 2024. All Rights Reserved.