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

fajemile's avatar
fajemile
Frequent Visitor
7 years ago

Hi v-juanli-msft

 

Thank you for that amazing solution it was exatly what I was looking for!

 

I have however stumbled onto another hurdle. All the attriubutes are exactly how I want them and the radar chart is perfect the only problem now is that I cant get it to interact with the image custom visual. I have done an example with the file you attatched. 

 

 

I am using the simple image custom visual. I know you said do not make a realtionship between the tables. I put in a new sheet with the image details in them, i then tested some of the tables relationships with the new sheet2(image sheet) to see which one would work. no relationship did not change the photos, 1 relationship changed 1 photo and 2 relationships flitered what was in the other slicer. I hope the photos make sense 

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

Hi fajemile

I try to only use one table, whenever i change the settings, it can't work well.

You need two tables with "name" and "photo url", then link each table to "newTable1" and "newTable2".

 table1 link to "newTable1, table2 link to "newTable2".

 

Best Regards

Maggie

  • fajemile's avatar
    fajemile
    Frequent Visitor
    7 years ago

    That's perfect thanks for the help Maggie