Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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
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!!!! 😃
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
100 | |
80 | |
63 | |
58 |
User | Count |
---|---|
148 | |
111 | |
94 | |
84 | |
67 |