radar chart filtered comparison

Hi fajemile

Workaround:

1.go to Edit Queries,

select columns (all columns you need to show as factor to compare) as below, then Unpivot columns

Close &&Apply

2. go to "Modeling"->New table

enter the code in the fomular bar

newTable1 = VALUES(Sheet1[player display name])

then create another new table by entering code

newTable2 = VALUES(Sheet1[player display name])

add columns "player display name1" in "newTable1", "player display name2" in "newTable2" in two slicer

note, don't create relationships between these tables, just keep it as below

3.create measures in "Sheet1"

slicer1 = ALLSELECTED(newTable1[player display name1])

slicer2 = SELECTEDVALUE(newTable2[player display name2])

value-slicer1 = CALCULATE(SUM(Sheet1[Value]),FILTER(Sheet1,Sheet1[player display name]=[slicer1]))

value-slicer2 = CALCULATE(SUM(Sheet1[Value]),FILTER(Sheet1,[player display name]=[slicer2]))

Best Regards

Maggie