How To Apply Drill Through In Power Bi

by

How to Apply Drill Through in Power BI

Drill Through in Power BI allows users to navigate to more detailed data within a report. It enables users to focus on specific aspects of the data and gain deeper insights. To apply drill through in Power BI, follow the steps below:

  1. Create a new report page by clicking on the “New Page” button in the Pages pane.
  2. Add visuals or charts to the new report page that will serve as the drill through targets.
  3. Select the visual on the original report page that you want to enable drill through on.
  4. In the “Visualizations” pane, click on the “Drillthrough” button.
  5. In the “Field” section, select the field that you want to use for drill through.
  6. Click on the “New Drillthrough” button to define the drill through page.
  7. Choose the drill through page layout and add visuals or charts that display the detailed data.
  8. Select the drill through visuals and configure the fields or measures to display the desired data.
  9. Repeat steps 5-8 for any additional drill through fields or pages.

Here’s an example to illustrate how to apply drill through in Power BI:

Let’s say you have a sales report with a visual that shows the total sales by region. You want to enable drill through functionality to allow users to view the detailed sales data for each region.

  1. Create a new report page and add visuals that will show the detailed sales data such as a table or a chart.
  2. Select the visual on the original report page that shows the total sales by region.
  3. In the “Visualizations” pane, click on the “Drillthrough” button.
  4. Select the “Region” field as the drill through field.
  5. Click on the “New Drillthrough” button.
  6. Choose the layout and add visuals to display the detailed sales data for the selected region.
  7. Select the new drill through visuals and configure the fields or measures to display the desired data such as sales by product, sales by customer, etc.
  8. Repeat steps 4-7 for any additional drill through fields or pages, for example, enabling drill through by product category.

By following these steps, you can easily enable drill through functionality in Power BI and provide users with a way to explore and analyze data in a more detailed manner.

Leave a comment