Home>Blogs>Power BI>3 Ways to use the Drill Through in Power BI
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.

Meet PK, the founder of PK-AnExcelExpert.com! With over 15 years of experience in Data Visualization, Excel Automation, and dashboard creation. PK is a Microsoft Certified Professional who has a passion for all things in Excel. PK loves to explore new and innovative ways to use Excel and is always eager to share his knowledge with others. With an eye for detail and a commitment to excellence, PK has become a go-to expert in the world of Excel. Whether you're looking to create stunning visualizations or streamline your workflow with automation, PK has the skills and expertise to help you succeed. Join the many satisfied clients who have benefited from PK's services and see how he can take your Excel skills to the next level!