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