To add a drill-through button in Power BI, you can follow these steps:
- Create a new report page that will serve as the drill-through page.
- Design the drill-through page by adding visuals and configuring filters or slicers as needed.
- Go back to the original report page from where you want to initiate the drill-through action.
- Select the visual (e.g., a chart) that will trigger the drill-through action.
- In the “Visualizations” pane, locate the “Format” section.
- Expand the “Action” section.
- Toggle the “Drillthrough” option to “On”.
- Click on the “Type” dropdown and select the desired drill-through page.
- You can also specify additional drill-through fields by clicking on the “Fields” dropdown and selecting the relevant fields.
- Customize the drill-through button appearance by modifying the “Button” section in the “Format” pane, like changing the text or background color.
By following these steps, you have successfully added a drill-through button in Power BI.
For example, let’s say you have a report with a sales chart and you want to drill down into specific regions. You create a new drill-through page that shows detailed information about sales per region. Then, you configure the sales chart on the main report page to allow drill-through to the region details page. When users interact with the sales chart and click on a specific region, they will be taken to the drill-through page where they can see the detailed information.