Drill through feature in Power BI

A drill through button in Power BI is a button that drills through to a page with details that are filtered to a specific context. One way to drill through in a report is to right-click in a visual.

Why to use drill through button?

• This action type creates a button that drills through to a destination page to get details that are filtered to a specific context.

When the user clicks on the button, he will be redirected to the detailed view of the data with all the filters applied for the same context.

HOW TO CREATE DRILL THROUGH

• STEP 1: Select the Matrix chart, drag and drop the State to the row’s fields and Sales, Profit, Customers and Qty Sold in values area to create state-wise chart.

STEP 2: Select the Matrix chart again and drag and drop the City to the row’s fields and Sales, Profit, Customers and Qty Sold in values area to create city-wise chart.

STEP 3: We will create new page in that we will create city-wise chart once again also store-wise matrix chart keeping store in the row’s fields and Sales, Profit, Customers and Qty Sold in values area.    

STEP 4: Now, we will create new page in which we will create category-wise matrix chart keeping product in the row’s fields and Sales, Profit, Customers and Qty Sold in values area. 

STEP 5: Now, we will create a new page and in that, we will create sub-category-wise matrix chart keeping product in the row’s fields and Sales, Profit, Customers and Qty Sold in values area.