Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

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.

Reply
miltenburger
Helper V
Helper V

Radar chart options

Hi guys,

 

I have a queation about the radar chart. 

I have several competences added to a member of the team. Each competence gets a score between 1 and 5.

 

So for instance 1 of my members got the following score (picture 1)

 

When i put this in a radar chart it looks like this (pictrure 2)

But when i have all my scores for instance on 4, it looks like this (picture 3)

 

Scores.pngRadar1.pngRadar2.png

 

 

 

 

 

 

 

 

 

 

 

 

What i want, is that my maximum score is always 5, so in picture 3 the radar should not go till this last line, but 1 before. You got my problem? Hope you can help me

 

Kind regards

 

 

 

 

 

 

 

1 ACCEPTED SOLUTION
cjayaneththi
Helper I
Helper I

Simple solution for this is to add maximum value for each competency that is 5 and bring both into Y Axis and change the colors..Capture.PNG

 

 

View solution in original post

6 REPLIES 6
cjayaneththi
Helper I
Helper I

Simple solution for this is to add maximum value for each competency that is 5 and bring both into Y Axis and change the colors..Capture.PNG

 

 

Hi , 

 

I have chosen Max value 4 - for Red, Max Value 3 - for Orange, Max value 2 - for yellow , Max value 1 - Green.

 

But some how it is showing only lines but not filled colors. Could you pelase help me in this regard. 

 

Thanks and Regards

Ravindra Babu Aluru

Thanks @cjayaneththi,

 

This is briljant and yet so easy haha! You're a genius!!

Also thanks for your reply @Eric_Zhang for testing some things out!

 

thanksman.png

 

 

 

Hello

 

I have the same problem as @miltenburger but I still didn't understand your solution @cjayaneththi I'm sorry.

Can you be please more specific on how to add a maximum value ?

 

Thank you very much

@kamsbenj,

You have to add the maximum value in your dataset, so create a new column max value, and put the values in

Eric_Zhang
Employee
Employee


@miltenburger wrote:

Hi guys,

 

I have a queation about the radar chart. 

I have several competences added to a member of the team. Each competence gets a score between 1 and 5.

 

So for instance 1 of my members got the following score (picture 1)

 

When i put this in a radar chart it looks like this (pictrure 2)

But when i have all my scores for instance on 4, it looks like this (picture 3)

 

Scores.pngRadar1.pngRadar2.png

 

 

 

 

 

 

 

 

 

 

 

 

What i want, is that my maximum score is always 5, so in picture 3 the radar should not go till this last line, but 1 before. You got my problem? Hope you can help me

 

Kind regards


@miltenburger

I‘m afraid it is all by design, the 3rd pic is just as expected. Note that the level of grid lines doesn't indicate the very specific 1,2,3,4,5. You could test with 1,10,100,1000,10000. Once all categories has the same value, it shows as the 3rd picture.

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

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