Radar chart

[IbrahimBathis]

Hi

I'm currently working on a project where I'm trying to create a dashboard with:
1. Map Visual: To show the location of districts.
2. Radar Chart: To compare five different "livelihood capitals" for each district (like a pentagon).
I'm running into some trouble getting these visualizations just right. Would anybody mind if I quickly picked your brain for some advice? I'm happy to share a sample of my data if that helps.  

first image  - what I am only possible to plot using my data shown in the table below.  the bottom image is what actually I want to plot so that the Pentagon shaped radar chart is interactive with the map visual, whenever I click on particular district it should show the Pentagon shaped radar chart for five capital..

Thanks so much!

[Anonymous · Accepted solution]

Hi @IbrahimBathis，

If you want to make the Category display five capitals, I think you need to unpivot your data table.

Please check the following steps:

1). Select the five capital columns and unpivot, you will get your table like below:

2). Configure the Map and Radar visual as below. Note that you could apply these settings to your customized map.

The pbix file is attached.

If you have any other question please feel free to contact me.