Others

How to Drill Through to a Specific Cell in a Power BI Matrix

Steve K Oct 19, 2026 869 views

Question details

The user wants to perform a drill-through action from a specific cell within a Power BI matrix to view its exact underlying data.

How to Drill Through to a Specific Cell in a Power BI Matrix

Product: Power BI
Device & OS: not provided
Scenario: Trying to navigate from a single measure value in a matrix to a detailed report page while ensuring only that specific cell's filter context is passed.
Observed behavior: Power BI natively passes the complete row and column context to the target drill-through page instead of treating the individually selected measure value as a standalone filter, causing the detail page to display results for the entire row.

Before you start

Ensure you have edit permissions for the Power BI report and a clear understanding of the row and column dimension fields that make up your matrix's filter context.

Solution 1Recommended

Configure Drill-Through Filters Using Row and Column Fields

By explicitly adding both the row and column dimensions to your target drill-through page, you can simulate a cell-level context.

Power BI does not natively support drilling through based solely on the displayed value of a single measure. Instead, the drill-through feature relies on the filter context, which is the intersection of the matrix's row and column fields. To achieve cell-specific results, your destination page must be configured to accept both dimensions.

Create a detailed target page

Add a new page in Power BI Desktop and design the table or visual that will display the detailed data.

Add fields to the drill-through well

In the target page's visualizations pane, drag the exact row and column fields used in your source matrix into the 'Drill-through' section.

Perform the drill-through

Return to your source matrix, right-click the specific cell you wish to investigate, and select 'Drill through' to navigate to your newly configured detail page.

Configure Drill-Through Filters Using Row and Column Fields

Filter Context Precision: This method ensures that the target page receives the intersection of both the row and column filters, closely approximating a cell-specific data view.

Solution 2

Use Conditional Bookmarks for Measure Values

If your drill-through requirement strictly depends on specific measure logic rather than dimensions, use custom navigation with bookmarks.

Free Microsoft Office alternative

Analyze Data Easily with WPS Spreadsheet PivotTables

While Power BI requires complex configurations for cell-level drill-throughs, WPS Spreadsheet simplifies data exploration. Using its powerful PivotTable features, you can instantly view the underlying data of any specific cell simply by double-clicking it. WPS Office provides a lightweight, fully featured, and highly compatible alternative for comprehensive data analysis.

1. Create a PivotTable: Open your dataset in WPS Spreadsheet, go to the 'Insert' tab, and click 'PivotTable' to structure your data with rows and columns.
2. Locate your target cell: Identify the specific value cell in your generated PivotTable that you want to analyze further.
3. Extract underlying data instantly: Double-click the selected cell. WPS Spreadsheet will automatically generate a new sheet displaying only the underlying data rows associated with that specific cell's filter context.

Double-click any PivotTable cell to instantly extract and view detailed drill-down dataSeamless format compatibility with Microsoft Excel (.xlsx, .xls, .csv)Lightweight application with built-in advanced data analysis and visualization toolsFree to use with a familiar, user-friendly interface requiring no learning curve

microsoft office alternative - wps office

Frequently Asked Questions

Why does Power BI drill-through pass the entire row context instead of the cell?

Power BI natively bases its drill-through behavior on dimension fields rather than isolated measure values. When you click a cell, it captures the row context. Unless the column field is also explicitly added to the destination's drill-through filters, Power BI evaluates the target page using only the row context.

Can I drill through based solely on a measure value in Power BI?

Not directly. Measure values cannot be passed as standalone drill-through filters. You must rely on the underlying dimension fields (rows and columns) to filter the target page correctly.

Is there a way to view underlying cell data without navigating to a new page?

Yes, you can right-click the matrix visual and select 'Show as a table' to see a broader dataset, or you can design custom Report Tooltips that display detailed visualizations or tables when hovering over a specific matrix cell.

Office Quick Solutions