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 in them which can be manipulated with slicers.

So in the photo this is what i am aiming for, the redded out slicers are names but as i change the name i want the radar chart to change to the corresponding player ect. I managed to do this with the values in the right hand side and the photo by changing interactions ect but wanted to know if the selected slicers could be put in the categories?

 

Thanks all aim not sure if i made sense but please send me a message for clarity 

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

9 Replies

  • fajemile's avatar
    fajemile
    Frequent Visitor
    7 years ago

    Note: That radar chart is just a picture from excel i wanted to use as an example of what I am aiming for. I would ideally like to use the data on the right hand side

  • v-juanli-msft's avatar
    v-juanli-msft
    Community 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

     

     

    • fajemile's avatar
      fajemile
      Frequent Visitor
      7 years ago

      Thanks for the reply Maggie maybe this will make more sense 

      The redded out slicers are the names of the participants Carlton and Stephen. I want the player names to be put in categories and then interact with the two slicers so I would be able to do a direct comparison on the radar chart with Carlton and Stephen for the values put into the y axis but then if I change slicer 1 to manny now there is a comparison between manny and Stephen in the radar chart. 

       

      The values on the right are columns from a table this part is irrelevant but i put it there to show that at the moment I am comparing the participants by creating a copy of the player column and then changing the interactions between the slicers. So if I change slicer 1 to another player all the values and picture would change to the corresponding player. 

       

      Ideally like in the picture if I could put the slicer 1 and 2 in the categories field that would be perfect but I don't think it works and was hoping somebody had a work around

       

      This is the aim but instead of team having slicer 2 there 

        

      • v-juanli-msft's avatar
        v-juanli-msft
        Community 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