Use Matrix Selection to filter my report

Hi erics44 

 

Maybe you can do what you need by drill through, here is my testing:

 

I'm using this sample data.

 

I created a Matrix as follow.

 

Page 2:

 

Page 3:

 

You need to set the Drill through filter field in Page2 and Page3, I used the Profit field.

 

 

I selected a cell in the Matrix and right clicked, you can choose Drill through to Page 2 or Page 3.

 

Result:

 

Page2:

 

Page3:

 

For more information about Drill through, you can refer to this document: Set up drillthrough in Power BI reports - Power BI | Microsoft Learn

 

Best Regards,
Yulia Xu

 

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