Forum Discussion
Solved
Formatting data for Radar Charts
Hi there, I’m trying to build a radar chart, and recreate what I’ve created in Excel within a Power BI dashboard – showing two quarters worth of scores for various different skills, with having t...
Hi davidburch,
Open Query Editor mode, select all 'skills' fileds, then click "unpivote columns" button. Remember to rename new columns.
Then, choose [Quarter] field, click 'Pivot Column' button.
With above changes, you will get a new table structure as shown in below image.
Create radar chart like below.
Best regards,
Yuliana Gu
Hi davidburch,
Open Query Editor mode, select all 'skills' fileds, then click "unpivote columns" button. Remember to rename new columns.
Then, choose [Quarter] field, click 'Pivot Column' button.
With above changes, you will get a new table structure as shown in below image.
Create radar chart like below.
Best regards,
Yuliana Gu
Thanks so much!!!! =)
