3 Ways to drill through
Power BI

3 Ways to use the Drill Through in Power BI

In this article, you will learn 3 different ways to Drill Through in Power BI. Drill through is used to navigate different pages within the report with the filter of selected data point like Supervisor, supplier, customer, or manufacturer.

Learn how to create drill through page in Power BI report

3 ways to use the drill through in the Power BI-

1: Right Click on the data point:

After creating the drill through the page in the Power BI, drill through in the Power BI, you can right-click on the data point then go to Drill through. It will show all the report pages name wherein drill through has been used for that point. You can select the page which you want to navigate.

Right Click to drill through
Right Click to drill through

2: Use Button to Drill through:

We can use the button also to use the drill through for selected data points. First, we have to create the drill through page then follow the below steps-

  • Insert a blank button from the Insert menu
  • Select the button and Format button pane.
  • Go to the Action and On it
  • Select Drill through in the Type
  • Select the report page name in the Destination drop-down
  • You can put some enable and disable tooltip if you want.

Now you will select a data point and click on this button, it will take you to the destination page.

Button to use Drill Through
Button to use Drill Through

3: Use Modern Tooltip:

Power BI has launched their Modern Tooltip in May 2021 Version. It is in Preview Features in this version. Just enable it from the File>> Options and Setting >> Options >> Preview Features >> select Modern Visual Tooltip

You need to restart the Power BI desktop application. Now open your report and again go to the File>> Options and Setting >> Options >> Report Settings >> Modern Visual Tooltip and check the “Use modern visual tooltips with drill actions and updated styling”

Click on OK

Now if you will hover on a related data point, it will show drill through the button on the tooltip.

Modern Tooltip in Power BI
Modern Tooltip in Power BI

Watch the step by step video tutorial to learn these 3 ways of drill through:

Click here to download the practice file.

My Name is PK. I am founder of PK-AnExcelExpert.com. I am a Microsoft Certified Professional. I have more than 12 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.