Forum Discussion
How to build this Radar Chart
Hello, I’m new here and have a problem with the correct display of my radar chart.
I have an Excelsheet of the following type.
| Name | Pillar | Status | Skill 1 | Skill 2 | Skill 3 | Skill 4 | Skill 5 | Skill 6 | Skill 7 | Skill 8 | Skill 9 | Skill 10 |
| MR. X | PD | Actual | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 |
| MR. X | PD | Target | 2 | 3 | 4 | 2 | 3 | 4 | 2 | 3 | 4 | 2 |
| MRS. Y | FI | Actual | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 |
| MRS. Y | FI | Target | 5 | 4 | 3 | 5 | 4 | 3 | 5 | 4 | 3 | 5 |
In Category, I would like to have the skills and in the Y axis Actual and Target.
Also I would like to use a filter to select the person and pillar (name, pillar).
When I write the skills in the rows of the table, I can assign it to the category, but the values cannot be assigned correctly.
Do I have to create different tables and define relationships or does this work differently?
I’m a bit confused 🙂
Thank you very much for your help!
Greetings
Hi ThorstenD - you can transform your data so that the skills are in a single column and you have separate columns for the actual and target values
In power query editor, select the columns Name, Pillar, status and perform unpivot other column transformation.
after performing :
perform pivot by selecting the value
set the value column as the value column and ensure status is set as the pivot column.
after pivot
This will create separate columns for actual and target values as above apply the changes and load it.
Hope it works,
you can take charts like clustered chart and build the visual.
Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!
2 Replies
Hi ThorstenD - you can transform your data so that the skills are in a single column and you have separate columns for the actual and target values
In power query editor, select the columns Name, Pillar, status and perform unpivot other column transformation.
after performing :
perform pivot by selecting the value
set the value column as the value column and ensure status is set as the pivot column.
after pivot
This will create separate columns for actual and target values as above apply the changes and load it.
Hope it works,
you can take charts like clustered chart and build the visual.
Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!Thank you, sir. It works really well.
It is important to pay attention to which column is pivoted second.
I wasn't clear about the double pivoting. I need to get even more familiar with this.
