cancel
Showing results for
Did you mean:
Highlighted
Helper V

Hi guys,

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)

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

Accepted Solutions
Highlighted
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..

6 REPLIES 6
Highlighted
Microsoft

@miltenburger wrote:

Hi guys,

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)

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.

Highlighted
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..

Highlighted
Helper V

Thanks @cjayaneththi,

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

Highlighted
Regular Visitor

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

Highlighted
Helper V

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

Highlighted
New Member

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

Announcements

#### Power Platform Community Conference

Check out the on demand sessions that are available now!

#### Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.

#### Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021