beehexa integrationsidebar
beehexa beehexa logo 1

We Build HexaSync Integration Platform for Connecting ERP, POS, CRM, Accounting, and eCommerce Applications to Automate Business Processes

How To Add Power BI Drill Through in 2024

Power BI is a powerful data visualization tool that allows users to create interactive and detailed reports. One of the features that enhance its interactivity is the drill through functionality. Power BI drill through enables users to navigate from one report to a detailed page focused on a specific data point. This feature is useful for detailed analysis, offering an easy way to explore data at different levels of detail.

This blog will guide you through the steps to add drill through to your Power BI reports in 2024.

What is Power BI Drill Through?

If you are not familiar with Power BI, please read What is Power BI before proceeding.

Power BI Drill Through

Drill through in Power BI is a feature that allows users to navigate from one report to a more detailed report page focused on a specific data point. For instance, a user can click on a sales summary for a particular region and be taken to a detailed sales report for that region. 

This functionality enhances the interactivity and depth of reports by enabling users to explore data at various levels of granularity.

Download Practice File

Open this link for Power BI Drill Through Sample. Then select Download to download the Drill Through Sample.pbix file to your computer. This visual is on the Returns page of the report.

Download Answer.

Step-by-Step Guide to Adding Drill Through in Power BI

After downloading the practice file from the previous step, follow these detailed instructions to Create a Power BI drill through.

1. Prepare Your Data

AD 4nXetSYpeJBrGlEPXFe600k2aJdCd7ZJxVH EJPl NiqxbywMDGoL3iB6JNSgSv46iMy6iPWVoSjTbaUkOZyaXeGSHx 6B4Qzun5 0mfFNytGYbUISbFYEH87K8tfZVw5mlrav0a9tlC35BKKrnvjPCW1dM8 ?key=56XTRRiJhpTpeq4wopRQsw

Before setting up Power BI drill through, ensure your data model is properly organized. The tables should be related correctly, and the fields you want to use for drill through should be included in your data model.

  • Relationships: Verify that the tables in your data model have the necessary relationships set up.
  • Fields: Ensure the fields you want to drill through on are available and properly formatted.

2. Create the Destination Page

The destination page is where users will land when they use the drill-through feature.

Add a New Page: Click on the ‘+‘ icon at the bottom of Power BI to add a new report page.

AD 4nXfluaK

Design Your Page: Design this page to display detailed information. For instance, if you’re drilling through from a sales summary to detailed sales data, add visuals like tables, charts, or KPIs that provide in-depth insights about sales

AD 4nXcenf 9ukr6DPaRD19oZXrIotVAtk d7RXImgSbSmDqmgq7M7mTqNq1HwwjE9OMTWXnXqETPsFb ysHxU1o6OaYHWec7qCClxpc u7Gk cbML7SmRVyTGETjNiSc5JADpqbdU03 DF2 vgFWPpvHhgjoHY?key=56XTRRiJhpTpeq4wopRQsw
AD 4nXfaCZRaJS6gmD0rmYVDQQuxOQ5RuelAQu4wspmGoOBfpnUkziYtNomIdbJXsT7VMjga86XYCTx23yJ3aq84XL 6g5e8VP67 YVmw1RK5cpxaxSR5IL4gSqYR BqdA4irvD NeBvEZmrfaL7vhu8VSCvDaM?key=56XTRRiJhpTpeq4wopRQsw

3. Add Drill Through Filters

Now let’s start adding drill through to your report.

AD 4nXcmlbbrkJyZYcAmOX12iA9OcokEYxxtYNkJAKvvzKPXYzGbM6M rpRjcibcx1V1hFpsiBwnk83Ht
AD 4nXdBdf6XPs21skSGnInsqRzhDmD0itYo F8VQNwARWiRh NnVUwnQKZC0cEcYHEPwvKDj lMTzXY3lqOKDGqugWEJA9Q88FlK5gygE9Kg6E5EKoe8IZttXo06b7qdwvoHXmcKuM oCtqg1 3kPjD0CPh0vE?key=56XTRRiJhpTpeq4wopRQsw
AD 4nXeVtdJMGQEMyQAvAwMkpZscBZfPO fm8jLbBjSn9J6Vl21eSZNbdkFL0MdIZL AeBfLmB38RBzorMIdmAirBAK2AcIbqnaLmdjR kKEKAICQgdh78eLEAC5U83N0oA GCHBQbhLGgGBB 5fP5X80DFYjgY?key=56XTRRiJhpTpeq4wopRQsw

4. Add a Back Button

It’s good practice to add a back button, allowing users to easily return to the previous page.

Insert a Button: Go to the “Insert” tab, and select “Button.”

AD 4nXe gHtRjwxKtgB5RSlNELmrLF4e6j zybGhQIzEoXguzqY 37J6gPu1t936Vw6bsY7mgLGHfiOtmUR5ZDBcyxspUsM60o09LilX629Nsmwg2xnWghNjL oUMLiwBY5MoTGVgHj4E3TWtCBFyRcvYTb NYyG?key=56XTRRiJhpTpeq4wopRQsw

Choose a Button Type: Choose a button type, such as an arrow or a simple rectangle.

AD 4nXfYg6CTMgh2DBpb05PXU hsg7xkRf9GYQbTBoJieMjP4b6SZ vSS4VAssyWnNF8ul07b5wOd8yRrsabBfJrGlx3EnNRxPnVf8HEX6 bn7VLnAcE4bjOFe2vyB XeGbYgRQfJRn 8vQpsWNCGCyR6CCaJJt9?key=56XTRRiJhpTpeq4wopRQsw

Set Button Action: With the button selected, go to the “Action” pane, toggle the action switch to “On,” and select “Back” as the type of action.

AD 4nXcig0F88zORXwnT0fDLe2Ep9kodHutwL8PwiUO3sB2T3BptEOljhAxINjxvXYr6Gq1ZbRsIB2UKuY6AF CTWvY QLU4hNZW Hm4V8ew6as7WfwAcdaYo5hrrtHUD8QDvuc aJhJpDu1XTmQ72Sb2MFZsqZ2?key=56XTRRiJhpTpeq4wopRQsw

Style the Button: Customize the button’s appearance to fit the design of your report.

AD 4nXdjYfJIQISR1c7KS4UvAFTEihOWdTpWXQbt3vEMMsvotoN1MhigotVBnzjedP0BSZv msJduY6m1CC3BKT7F25Ixa

5. Set Up the Source Page

The source page is where users will initiate the drill-through action.

AD 4nXfIW3myW6PTK4i2SPXszfme07AI9ISQQ8ZBKJPawk0fbpgivKqObTSQ6wtudY6v3k2K5Ew2zPdSi6cF7YF3LWYQ3eOMqIMMSkWgZJ7uFf9fJA4W
  • Select the Visual: On the source page, select the visual from which you want to enable drill through.
  • Enable Drill Through: Right-click on a data point in the visual. If the drill-through is set up correctly, you will see the drill-through option in the context menu.

7. Test Your Power BI Drill Through

It’s crucial to test the drill-through functionality to ensure it works as expected.

  • Right-Click and Drill Through: Right-click on a data point in your source visual, and choose the drill-through option. Verify that it navigates to the detailed report page with the correct context applied.
  • Check the Back Button: If you added a back button, click it to ensure it returns you to the source page.


Drill through is a powerful feature in Power BI that enhances report interactivity and provides users with detailed insights effortlessly. By following the steps outlined above, you can add drill through to your Power BI reports, making your data exploration more dynamic and intuitive. Whether you’re drilling down into sales data, customer demographics, or any other data point, this feature ensures you can provide detailed and focused analysis at your fingertips.

By implementing Power BI drill through, you can significantly improve the usability and depth of your reports, making them more valuable for your audience. 

Table of Contents

Ready to integrate and automate at scale ?

Learn how HexaSync lets you build enterprise-grade integrations and automations without having to code.

Receive Exclusive Productivity Tips Directly in Your Inbox

We’ll email you 1-3 times per week—and never share your information.

Get started for free

You can’t add more hours to the day. Beehexa is the next best thing.