Forum Discussion

ngiam's avatar
ngiam
Helper I
5 years ago
Solved

Amending Data for Radar Chart

Hi there,

 

I'm trying to create a radar chart that shows the skill of an employee as rated by others.

 

Category will be the attribute. 

 

1. While the value on the chart should show the self value (by attribute), superior value (by attribute) and team member value (by attribute average). I'm a little stuck at this stage and am not sure how to proceed with the data from here. Appreciate help in this area. My data as attached in the pic.

 

2. After resolving the above, I plan to use the department to filter out response by department. I assume that the department column will enable this too?

 

Thank you in advance

 

 

Need Help
  • PhilipTreacy's avatar
    PhilipTreacy
    5 years ago

    Hi ngiam 

    To display the average score, chnage the aggregation on the value to Average.

    Does that solve your problem?

    Regards

    Phil

6 Replies

  • PhilipTreacy's avatar
    PhilipTreacy
    Super User
    5 years ago

    Hi ngiam 

     

    Download example PBIX file

     

    When asking a question, please supply data as text/file/table rather than a picture so we don't have to type it all out again.

    In the attached file I have recreated some of your data, and produced these visuals.  See if this starts you off towards where you want to get to.

    There are 3 slicers so you can filter by Name, Dept and Designation.

    The table is there just to check the data against the radar chart, you can remove it if you like.

    Please reply if you need more help. 

     @ mention me in replies or I will miss it.  Type@ then select my name.

    Regards

    Phil

    • ngiam's avatar
      ngiam
      Helper I
      5 years ago

      Hi PhilipTreacy ,

       

      Good point, I'll put the excel file in the next round.

       

      As for the radar chart, my biggest challenge is to ensure that the self, superior & team members average score are appearing in the radar chart at the same time.

       

      The slicer for the department will help to filter the average score by dept after that.

       

      Appreciate your help on this!

      Ngiam

  • PhilipTreacy's avatar
    PhilipTreacy
    Super User
    5 years ago

    Hi ngiam 

    To display the average score, chnage the aggregation on the value to Average.

    Does that solve your problem?

    Regards

    Phil

    • ngiam's avatar
      ngiam
      Helper I
      5 years ago

      Hi PhilipTreacy ,

      Thank you very much for your kind support

      I was referring to having self, peer & team members score appearing on the radar chart at the same time for comparison.

       

      I'm having trouble putting all 3 at the same time.

  • PhilipTreacy's avatar
    PhilipTreacy
    Super User
    5 years ago

    Hi ngiam 

     

    Download sample PBIX file.

     

    I've created 3 measures to display the info you want. 

    Self Score = CALCULATE(SUM('Table'[Value]), FILTER('Table', 'Table'[Designation] = "Self"))
    Superior Score = CALCULATE(SUM('Table'[Value]), FILTER('Table', 'Table'[Designation] = "Superior"))
    Team Member Score = CALCULATE(AVERAGE('Table'[Value]), FILTER('Table', 'Table'[Designation] = "Team Member"))

    Note the Team Member scores shows the average score across team members.

    The result is this

    You might want to modify the colors for the different measures to suit your tastes.

    Regards

    Phil

    • ngiam's avatar
      ngiam
      Helper I
      5 years ago

      PhilipTreacy , 

      THANK YOU! You've been a great help.

      Seems like I need to learn more about using measures!