Drillthough allows you to view a report page for specific detail. For example, you can have a 2 page report
- Page 1 with overall business summary
- Page 2 with store level performance details
With drillthrough on page 1, when you select a store, you can view Page 2 for that store.
Drillthroughs are easy to setup and use in Power BI. In this lesson, we will use Retail Dashboard casestudy to create a drillthrough functionality and store performance report.
Related links:
Author: Chandoo
My name is Chandoo. I am going to make you awesome in Excel, VBA, Dashboards, Power BI & Power Pivot and answering your questions.
I live in Wellington, New Zealand. It is a beautiful, small city on the southern edge of the world. I run my own Excel Consulting & Training business from here.
I am married to my college sweet-heart, Jo. We have 2 kids – twins. They are 10 years old now. They are busy creating new worlds with lego bricks or playing or learning. We (Jo &I) are busy with cooking, eating, walking, talking and reading.
View all posts by Chandoo