Forum Discussion
Structuring data for radar chart
Hi All, this forum has been super useful in my PowerBI learning journey as I'm able to solve 80% of the questions just from reading this forum alone !
However, recently I've encountered some issues to produce the following visual with Radar Chart, where i would like to overlay each City (represented by different coloured lines) as I toggle the City Name in the slicer:
My sample data set used to generate the above radar chart is as follows:
City | Attributes | Rank |
Adelaide | Crime Rate | 1 |
Adelaide | Unemployment Rate | 3 |
Adelaide | English Proficiency | 1 |
Adelaide | GDP | 2 |
Adelaide | Air Passenger | 3 |
Beijing | Crime Rate | 2 |
Beijing | Unemployment Rate | 1 |
Beijing | English Proficiency | 2 |
Beijing | GDP | 1 |
Beijing | Air Passenger | 1 |
Pune | Crime Rate | 3 |
Pune | Unemployment Rate | 2 |
Pune | English Proficiency | 3 |
Pune | GDP | 3 |
Pune | Air Passenger | 3 |
Currently, i've placed "Attributes" under Category and "Rank" under Y-Axis. I can't pivot the City column as it is the main link in the relationship to my other data sets.
Appreciate if anyone has a good suggestion to the above visual.
Thank you !
7 Replies
HI slackerhx,
I'd like to suggest you to take a look at following link to know how to achieve multiple axis.
Power BI Custom Visuals - Radar Chart
Regards,
Xiaoxin Sheng
Hi Xiaoxin,
Thanks for the suggestion, unfortunately, it doesn't achieve my intended visuals as the Category section only accepts one field instead of two (which for my case is "City" and "Attributes").
I've also tried pivoting the respective attributes to form column names with the values filled by the respective ranks of each city but it still doesn't achieve the desired outcome.
HI slackerhx,
For this requirem, you can submit an idea or contact custom visual team to get more support.
In my opinion, I think current it impossible to achieve your requirement on radar visual.
BTW, you can also try to use R visual to draw these graph.
Regards,
Xiaoxin Sheng
How to fill custom colors for each circle of this radar chart as similar to Excel filled radar chart.
