Set up drill through for matrix visual to table visual

Hello! On the page where your table visual is (the drillthrough page), do you have it marked as a drillthrough page in the page type in the formatting for that page? Also, do you have the dimensions you want ppl to be able to drill on in the 'Drill through from' section? For example, you would likely want to have Item, Baan No., Description and Material, that way no matter which one of your dimensions someone right clicks on in the matrix, they can drillthrough.

Set up drillthrough in Power BI reports - Power BI | Microsoft Learn

Thanks for the reply from audreygerred.

Hi Anonymous ,

If you need to set up drillthrough, you need to have an identical field on both the drillthrough page and the target page, by which you can drillthrough.

Expanding on audreygerred's  response to show you the exact steps, here is a simple example:

1.Drag the country to the drill through pane:

2.Right click on Canada to drill through to page2:

3.Then you can jump to page2 and filter the profit with the country of Canada:

In addition, you can use multiple fields for more sophisticated drill-throughs. For example, you can use both the Country and Month Name fields for multi-dimensional drill-through analysis.

Best Regards,
Zhu
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.