How to build this Radar Chart

[ThorstenD]

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

[ThorstenD]

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.

[rajendraongole1 · Accepted solution]

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!!