Filter Different Rows in Matrix

[majinvegito123]

Hi guys. I'm converting a lot of data from Microsoft Excel over to PowerBI. I currently have an excel spreadsheet that creates 7 different pivot tables with slightly different data. I wanted to know if there's a way to just filter different rows in a PowerBI matrix. Reason being is that all 7 of these pivot tables use EXACTLY THE SAME column and values, just a different row.

Example:
Pivot 1:

Row: Salesperson

Column: Mth

Values: OrderValue

Pivot 2:

Row: RSM

Column: Mth

Values: OrderValue

etc.

I was wondering if perhaps for example I could add a slicer that allowed me to pick what i wanted my "row" to be in the Matrix. IS there a way to do this or do I need 7 different matrices?

[Greg_Deckler · Accepted solution]

@majinvegito123 I believe that this is the purpose of Field parameters.

[majinvegito123]

Awesome! Just what I needed. I was not aware this was a feature and I had to enable it in the options. Thanks for bringing this to my attention