Drillthrough
Power BI

Drill through in Power BI

In this article you will learn how use Drill through in Power BI. You can create a page in your report that focuses on a specific entity such as Supervisor or Employee. Users can right-click on a data point in other report pages. Then they can drill through to the focused page to get details that are filtered to that context.

We have our main page wherein we have a supervisor wise sales doughnut chart. We have added two new pages as “EMP wise Sales” and “Sales Drill down”. On the new pages move the Supervisor Filed in DRILLTHROUGH filter.

DRILLTHROUGH filter
DRILLTHROUGH filter

Now if you will right click on supervisor slice and go to drill through then you will see “EMP wise Sales” and “Sales Drill down” in sub menu. Click on any one. It will take you to that page and filtered data for that supervisor will be available there.

Drillthrough in Power BI
Drillthrough in Power BI

 

Click here to download the practice file.

 

Watch the step by step video tutorial:

PK
My Name is PK. I am founder of PK-AnExcelExpert.com. I am a Microsoft Certified Professional. I have more than 10 years of experience in Data Visualization, Excel Automation and dashboard creation. Excel is my passion and I like to do always something innovative in Excel and share it with other people.
https://www.pk-anexcelexpert.com