Matrix visual with combination of data

[PowerBICouple]

I have a problem for a personal project around Overwatch 2 game data I just can't seem to wrap my head around. I have data in this format:

GameID | Map | Player1 Hero | Player 2 Hero | Player 3 Hero | Player 4 Hero | Result | Mode | Date Played

1 | Map1 | Hero1 | Hero2 | Hero3 | Hero4 | Win | Competitive | 01-01-2024

1 | Map1 | Hero5 | Hero6 | Hero7 | Hero4 | Win | Competitive | 01-01-2024

Each player can play multiple heroes per game. Each hero has a role (Tank, DPS, Support). I modelled this as follows in a star schema. Each row in the stats table is a unique player/hero/gameID

I have a winrate measure 

Win Rate % =

VAR Result = DIVIDE([Wins], [Total Games])

RETURN

IF(ISBLANK(Result) && [Total Games]>0,0,Result)

Ideally what I would like to see in a visual is:

But I can't seem to figure out if I need extra tables, or how I get it to properly visualize this. 

Thanks in advance

[Ashish_Mathur]

Hi,

In the Table that you have shared, there is no mention of Role at all.  Also, how do you interpret the table in the image that you shared.

[PowerBICouple]

Role is part of the hero dimension. Each hero has a role, it's added subsequently to the initial data from a list of heroes and roles

The interpretation is that when Player 1 plays tank and Player 2 plays support the winrate is 54%

[PowerBICouple]

Role is in the Hero dimension

Each hero has a role (Tank, DPS, Support)

The interpretation is that when Player 1 plays tank, and player 2 plays support (in the games where both of those is true) the winrate is 54%

[lbendlin]

yes, if you want to compare players against each other you need at the very minimum two disconnected tables, one for each player selection (which would then go on the rows and columns of the matrix). Then use measures to fill the values of the matrix