How to selectively pass field values to drill through page?

In Power BI, the drill-through feature helps users drill down to certain specifics on data by navigating from one report page to another. That’s the way it makes viewing detailed information possible without crowding the main report, yet providing such opportunities for analysis.

Drill Through Configuration:

Members using Power BI can set some specific fields within their dataset as fields for “drill-through.” Typically, these would be fields containing information that, when a user encounters it on a report, they may find interesting to drill down to — for example, Brand, Category, Item, Customer, or specific dates.

Click on the empty space on the page.

If on-object interaction is enabled, you can add a drill-through field under Page Information by selecting the Drill Through page type. In this case, you’ll find a section called Drill Through From.

If on-object interaction is not enabled, the same information is available in the Visualizations pane, where you’ll find a section labeled Add Drill Through Field Here.

Drill-through carries over all filters to the next page, even if they are not included in the “Drill-through” section.

To prevent a field from being passed during drill-through, disable the “Keep All Filters” option. This ensures that only the fields in the “Drill Through” section are transferred to the drill-through page.

Accessing Detailed Insights using “Drill Through”:

When you add fields to a drill-through page, the “Drill Through” option will appear on other pages when a user right-clicks on a visual containing those fields. The option will also display the names of the available drill-through pages.

“Drill-through” can also be activated using a button. When you click on a row, the “Drill-through” button becomes enabled. You can then click the button (Ctrl+Click on Desktop) to navigate to the drill-through page. The button can utilize a measure to dynamically select the appropriate drill-through page.