cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
slackerhx Regular Visitor
Regular Visitor

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: 

 

Radar query.PNG


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 7
Community Support Team
Community Support Team

Re: Structuring data for radar chart

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

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



For learning resources/Release notes, please visit: | |
slackerhx Regular Visitor
Regular Visitor

Re: Structuring data for radar chart

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. 

Community Support Team
Community Support Team

Re: Structuring data for radar chart

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.

Radar Charts in R

 

Regards,
Xiaoxin Sheng

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



For learning resources/Release notes, please visit: | |
slackerhx Regular Visitor
Regular Visitor

Re: Structuring data for radar chart

Hi Xiaoxin @v-shex-msft

 

Does plotly requires one to be well-verse in R script as I don't have any knowledge of it? Are there any other alternatives that can be used?

 

Thank you.

Community Support Team
Community Support Team

Re: Structuring data for radar chart

HI @slackerhx,

 

Nope, I haven't found any other custom visual can achieve this, maybe you can contact to custom visual team to submit this requirement.

 

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



For learning resources/Release notes, please visit: | |
slackerhx Regular Visitor
Regular Visitor

Re: Structuring data for radar chart

Highlighted
alururavi Frequent Visitor
Frequent Visitor

Re: Structuring data for radar chart

How to fill custom colors for each circle of this radar chart as similar to Excel filled radar chart. 

Helpful resources

Announcements
Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

Ask Amanda Anything Q&A

Ask Amanda Anything Q&A

Learn the answers to some of the questions asked during the Amanda Triple A event.

October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Solution Badges

New Solution Badges

Two waves of brand new solution badges are coming! Read the article for more information on our new community badges.

Users Online
Currently online: 146 members 1,644 guests
Please welcome our newest community members: