Head to head visualisation

[PetyrBaelish]

Looking at the image below, I want to create the visualisation from the right, based ont he data to the left.

The data is in a table called Results, where (among other fields) I am recording the date of a tournament, each player that played and the result (I also record in the result column if someobody started late by adding "(L)" to the end of it, so when looking at this column it's the left 3 characters that will need to be evaluated.

From this table we can see who was the winner and who was the runner up for a given tournament. I want to turn this into a visual as per the right of the image where we get to see a head-to-head record - that is how much each player has beaten the other player.

So from the data below Dave and Stephen have been first and second 4 times - on 3 occasions Dave won, on 1 occasion Stephen won - so that translates onto the visual as "3 / 1". That reads that Dave (in the row) has won 3 times / lost once against Stephen (in the column). What is below the grey diagonal line is effectively a reflection of what's above it and always would be.

I'd also like the 0's to be displayed instead of blanks in relevant scenarios.

The backslashes were part of my Excel formula in a concatenation - I'd like something to separate the two figures (e.g. separate the 3 from the 1).

I'm not sure how to achieve this in Power BI - any help would be much appreciated.

[v-lili6-msft]

hi, @PetyrBaelish

After my test, it may be difficult to achieve it. and you may try this way

Step1:

you need to group the data for each tournament.

Step2:

Then split two players for each tournament from one column to two columns.

These two steps could be done in Edit Queries.

and here is my pbix, please try it.

https://www.dropbox.com/s/zcio2j3f7mr6os0/Head%20to%20head%20visualisation.pbix?dl=0

Best Regards,

Lin