How to use Drill Through in Power BI Reports

In Power BI, there are a lot of features available which helps in enhancing the reporting experience. One of those amazing features is “Drill Through”. It helps a user to navigate to different pages within the same report.

Let’s have a look at, how one can add this feature in a report!

Visualize a page which contains an overview of a set of ‘items’ that a product company manufactures, and we want to have a look at the detailed information. So, here comes the drill through feature to our rescue which will enable us to go from one page to another for more detailed information.
But… There is a catch! It will only provide the detailed information for the “Items” that we select for drill down!

So, let’s proceed with its practical implementation…

  1. Let us display a bar chart of total sales amount of items by “Category” as shown below-

2. Now, we want to have a look at the sales numbers generated through “Subcategories” and for that we will just put the “Category” field into the “Drill-through” option available at the bottom of the Visualizations pane of an another page of the same report, where we have visualized Sales Amount of “Subcategories”. This can either be a Chart or a Matrix or anything.

Let me break this process…

Step-1: Create a matrix and select it-

Step-2: Go at the bottom of the Visualizations pane and reach to “Drill through” option-

Step-3: Drag “Category” from the Fields pane, and drop here at the field-box.

3. Once we have done that, we can go back to the main page where our “Sales amount by Category” is displayed. Doing a right click on the of the category names, and this will provide a drill through option. As we click on it, this will be redirecting to the secondary page where “Sales amount by Subcategory” has been visualized.

This small yet appealing feature can make your report alluring to the reporting end users. Such dynamic reports are easy to interpret the data and get the detailed insights easily with simple clicks.

This is how we can have a detailed explanation page in our report available on other page with just a click away.

I hope your purpose must have been solved now.
Thank you for reading.

Rajeshwari Sharma 
Data Analyst 
Addend Analytics 

Addend Analytics is a Microsoft Power BI-partner based in Mumbai, India. Apart from being authorized for Power BI implementations, Addend has successfully executed Power BI projects for 100+ clients across sectors like financial services, Banking, Insurance, Retail, Sales, Manufacturing, Real estate, Logistics, and Healthcare in countries like the US, Europe, Australia, and India. Companies partnering with us save their valuable time and efforts of searching and managing resources while saving hugely on the development costs and hence, most small and medium enterprises in North America prefer Addend to be their Power BI implementation partner. Get a free consultation now by emailing us at kamal.sharma@addendanalytics.com