what is drill through in power bi

Drill through is a feature in Power BI reports that allows users to create a destination target page in their report that focuses on a specific entity such as a supplier, customer, or manufacturer. When report readers right-click a data point in other source report pages, they drill through to the target page to get details that are filtered to that context. There are two types of drill through in Power BI: drillthrough within a report and cross-report drillthrough. To set up drillthrough within a report, users need to create a target page and enable drillthrough on that page. They can then drag the field for which they want to enable drillthrough into the Drill through well in the Build visual section of the Visualizations pane. Power BI automatically creates a back button visual, which becomes a button in published reports. Users who view the report in the Power BI service use this button on the target page to get back to the original source report page from which they came. To set up cross-report drillthrough, users need to create a target page and enable drillthrough on that page. They can then select a visual that uses the drillthrough field in the way they specified when they set up the target page. Cross-report drillthrough targets are formatted as Page name .