Forum Discussion
How to build this Radar Chart
- 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!!
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!!