Using a Matrix as a Slicer/Filter

[dtm644]

Hey Everyone - 

I've got a matrix which is laid out in a summary format (below). The numbers are just counts of each row/month the dataset is ~50columns deep and isn't the cleanest so I'm cleaning it in another matrix (same orginal data set). 

How would I go about giving the user the ability to click on one of the summary numbers/rows/subtotals and have the filter apply to the second tab?

Alternativly - can I create a 'see records' with custom columns?

[v-juanli-msft]

Hi @dtm644 

Is this matrix from your original data or a matrix visual on a Power BI report?

"click on one of the summary numbers/rows/subtotals and have the filter apply to the second tab"

What does this mean?

Click on 8 (for example), then ??

Best Regards
Maggie