Create a comparison report of data from the same table

[DebbieE]

Say I have the following table

Person     Win      Loose      Draw   Plays

A              3           7              0          10

B              5          8               1           14

C              7         10              3           20

D              10         4              2           16

E              11           1             12         23

I want to do a comparison report of 2 rows of data

For example, I choose player a and then for the comparitor I choose player D (This is just an example simple report)

                 Player A                                           Player D

 Win      Loose      Draw   Plays          Win      Loose      Draw   Plays

  3           7              0          10              11          1             12        23

And you could possibly show the lowest figure of the two in Red and the highest figure in Green.

So first of all, is this something you can do in Power BI? We cant think of doing it with Slicers because Slicers control the entire report?

Any help would be really appreciated

[Sansudhi8 · Accepted solution]

Hi,

Please see the attached. (Use Edit Interactions) 

PBI

[DebbieE]

Thants fantastic,

Thank you very much. Ididnt realise you could do this in Desktop. Thats great

Also I  need to figure out how to show the metric in green or red if its better or worse that the other player

[Sansudhi8]

Hi ,

See the attached file. i am not good with colors.  

PBI Edited 

[DebbieE]

Wow, thankyou so much,

Im guessing you cant do the same thing in the tables displaying the single persons data. So If player A has been selected with 3 wins and Player B is selected with 5 Wins 3 is red and 5 is green in the seperate tables?

Im guessing that would be two difficult because you are conditional formatting between two seperate tables

[Sansudhi8]

Hey Hi,

Lets leave it for some expert. 

"Im guessing that would be two difficult because you are conditional formatting between two seperate tables " Yes 

[Greg_Deckler]

2 slicers, 2 table visualizations, use Edit Interactions to control which slicer filters which table.