Using Drillthrough in Power BI is super useful for navigating from a summary view to a detailed view of your data. Here’s how to do it:
- 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.
- Add charts or bars that relate to the field. These visuals will now filter based on the selected data point from the main page.
