Forum Discussion

ThorstenD's avatar
ThorstenD
New Member
2 years ago
Solved

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 ...
  • rajendraongole1's avatar
    2 years ago

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