Forum Discussion

dtm644's avatar
dtm644
Frequent Visitor
7 years ago

Using a Matrix as a Slicer/Filter

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?

 

 

 

Need Help

1 Reply

  • v-juanli-msft's avatar
    v-juanli-msft
    Community Support
    7 years ago

    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