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

I don't understand your requirement.

 

Where is the the "redded out slicers"?

Are the values in the right hand side measures or columns from the table?

"if the selected slicers could be put in the categories"

which categories does the the slicers need to be put?

 

Could you show an example?

 

Reference:

Power BI Custom Visuals - Radar Chart

Multi-Variate Quantitative Analysis with Radar Charts in Power BI Desktop

 

Best Regards

Maggie