Forum Discussion

fajemile's avatar
fajemile
Frequent Visitor
7 years ago
Solved

radar chart filtered comparison

Hi All,   Ive looked up various forms and dont seem to be able to see the answer and was hoping someone could help me.    Essentially I am trying to look at a radar chart but have two categories ...
Need Help
  • v-juanli-msft's avatar
    v-juanli-msft
    7 years ago

    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

v-juanli-msft's avatar
v-juanli-msft
Icon for Community Support rankCommunity Support
7 years ago

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

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Solved!