Formatting data for Radar Charts

[davidburch]

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 the option to drill down to individual locations

 

I summarised the data in a table:

But when I created a radar chart, the radar ‘columns’ were Q1 and Q4, whereas I wanted these as radar ‘points’, with the ‘column headings’ being the skills

 

So I re-formatted the data with the skills as rows and then the date (Q1/Q4 together with the location) as columns.

This produces the right graph, however I want to be able to easily flick between locations (so you can just see the Q1 and Q4 figure for one location at a time).

I’ve attempted to add a ‘slicer’ box (as I did for the data with the original formatting) but I can’t see a way to filter between locations, as the locations are now part of the column headers? it now just produces a table of figures:

Any help in producing this slicer box together (to flick between different locations data) with the graph showing two quarters data as above would be much appreciated!

Thanks

[v-yulgu-msft · Accepted solution]

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

[davidburch]

Thanks so much!!!! 😃