Forum Discussion

ngiam's avatar
ngiam
Icon for Helper I rankHelper 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 ...
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

PhilipTreacy's avatar
PhilipTreacy
Icon for Super User rankSuper 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
Icon for Helper I rankHelper I
5 years ago

PhilipTreacy , 

THANK YOU! You've been a great help.

Seems like I need to learn more about using measures!