How to Fix Power BI Desktop Drill-Through Not Working
Question details
The user needs to resolve an issue where the drill-through feature in Power BI Desktop is missing or not functioning as expected.

- Product
- Power BI Desktop
- Device & OS
- not provided
- Scenario
- Attempting to navigate from a summary source visual to a detailed target page using the drill-through functionality.
- Observed behavior
- The drill-through command is unavailable or missing when right-clicking a data point on the source visual.
Ensure you are using the latest version of Power BI Desktop, as interface layouts and pane locations frequently update and may differ from older instruction guides.
Configure Target Page Fields and Verify Data Relationships
Properly set up the destination page's drill-through fields and ensure the data models between the source and target visuals are correctly related.
Power BI drill-through relies on an exact match between the fields used in the source visual and the fields placed in the drill-through well of the target page. If the setup is incomplete or relationships are broken, the option will not appear.
Navigate to the target report page that you want users to drill through to.
In the Visualizations pane, locate the 'Drill-through' section. Drag the specific categorical field you want to drill through into the 'Add drill-through fields here' field well.
Return to your main report page. Right-click a data point on a visual that contains the exact field you added in the previous step, and select 'Drill through' to navigate to the target page.
If the command is still unavailable, open the Model view on the left sidebar to confirm that a valid, active relationship exists between the tables powering the source and destination visuals.

Looking for a Lightweight Data Analysis Alternative?
While Power BI handles complex business intelligence, WPS Spreadsheet provides a free, fast, and highly compatible alternative for everyday data analysis, pivot tables, and chart visualization without the steep learning curve.
- 1. Open your dataset: Launch WPS Office and open your raw data files (.xlsx or .csv) using WPS Spreadsheet.
- 2. Create a PivotTable: Select your data range, go to the 'Insert' tab, and click 'PivotTable' to quickly summarize your data.
- 3. Drill down into details: Double-click any summarized value in your PivotTable to instantly extract and view the detailed underlying data on a new sheet.

Frequently Asked Questions
Why is the drill-through option completely missing when I right-click?
The drill-through option will not appear if the source visual does not contain the exact data field that was configured in the target page's drill-through well, or if the visual type does not support the action.
Can I use drill-through to navigate to a different Power BI report?
Yes, cross-report drill-through is supported. You must enable it in the Options menu under Report settings, configure the target report properly, and publish both reports to the same workspace in the Power BI service.
Does drill-through work with measures in Power BI?
Yes. When you drill through based on a category, you can pass measures and all other active filters to the target page by ensuring the 'Keep all filters' toggle is turned on in the destination page's drill-through pane.




