Creating a Drillthrough in Power BI lets users right-click a data point and jump to a detailed page focused on that item—great for zooming into specific products, regions, customers, etc. Follow these steps:
- In Power BI Desktop, add a new report page and select a data source.
- Go to the 'Visualizations pane'.
- Drag the fields you want to drill through on into the 'Drill through' filters well.
- The fields will appear in the drill-through area.
- Power BI will show a back button on the page automatically, this lets users return to the previous page.