Use Matrix Selection to filter my report

[erics44]

Hi

I would like to select a cell in a matrix and then all the other Visuals filter on that selection in multiple pages.

Could anybody help please.

Thanks in advance

[Anonymous · Accepted solution]

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.