Slicer show 1 persons data. Anther table in report relating to a field in the table 1

[DebbieE]

I have the following Data set

Person Win Lose Draw Plays Team

A         3      7        0       10     Blue

B         5      8        1       13     Blue

C         7      10        3       20     Blue

D         10      4        2       16     Red

E         11      1        12       23     Red

I need a slicer to choose the player and show their results in a table.

Then I need a second table showing the results of everyone in the red team

So if you choose Person A. You see there results

Under this another table with 3 rows for all the Blue Team players

Is there any way of doing this at all. Any help would be really appreciated

[Christann]

You could always try using two slicers.

[DebbieE · Accepted solution]

https://community.powerbi.com/t5/Desktop/2-Tables-1st-table-relating-to-slicer-2nd-table-related-to-...

These are some really good ideas on the same issue