Reply
tasjour
Frequent Visitor
Partially syndicated - Outbound

Dynamic Radar chart based on categories in dataset

I have a following dataset which contains an id column (a job role), competency column (skills required to perform a given job role), and a Level column (level of competency requied), and I like to use a radar chart to visualise what are the competency and level required to perform a given role. 

However, as you can see, the competency profile differs between each job id. 

tasjour_0-1733310301001.png

I started with the MS radar chart, but it shows all the competencies there are in the dataset.  

Is there a way to construct a radar chart that is dynamic so if I picked "Typical_APS_Content_Strategist_EL1" in the slicer, it produce a radar chart with competency categories of "ICPM", "INCA", "MEAS" and their relevent levels only, instead of showing all competencies there are in the dataset? 

tasjour_1-1733310590847.png

 

3 REPLIES 3
v-yilong-msft
Community Support
Community Support

Syndicated - Outbound

Hi @tasjour ,

I create a table as you mentioned.

vyilongmsft_0-1733366910897.png

Then I think you can use this visual.

vyilongmsft_1-1733367794333.png

vyilongmsft_2-1733368152541.png

You can add a slicer and it will give you what you want.

vyilongmsft_0-1733377424078.png

 

 

 

Best Regards

Yilong Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Syndicated - Outbound

Thanks Yilong, Is there another free visual that can produce the area, instead of line? xVIZ's radar chart needs Pro license to plot "area". 

 

Syndicated - Outbound

Hi @tasjour ,

I tried to do a free account login and also tried all the current radar charts I found:

 

Currently there are no free radar charts in Power BI Desktop as you would like.

 

They can only do part of what you need, not all of what you want.

 

 

Best Regards

Yilong Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

avatar user

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

FebPBI_Carousel

Power BI Monthly Update - February 2025

Check out the February 2025 Power BI update to learn about new features.

Feb2025 NL Carousel

Fabric Community Update - February 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)