cancel
Showing results for
Did you mean:
Highlighted
Member

## Conditional Coloring on Donut Chart based on value

Is there a way to acheive this on a donut/pie chart based on a % value?

For example:

>80% = Green

Between 40% and 60% = Yellow

<40% = Red

This feels like a basic requirement, but cannot seem to find this option anywhere. Is there something obvious im missing?

8 REPLIES 8
Microsoft

## Re: Conditional Coloring on Donut Chart based on value

Hi @rax99

You may try to add a column with IF condition. Then use 'Data colors' to show the color. For example:

Regards,

Cherie

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

## Re: Conditional Coloring on Donut Chart based on value

HI Cherie,

This does appears to be what I am looking for. Any chance you could upload a pbix file so I can take a deeper look. I have tried it with my report and doesnt appear to be working correctly.

Thanks

Microsoft

## Re: Conditional Coloring on Donut Chart based on value

Hi @rax99

Here is the file.

Regards,

Cherie

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

## Re: Conditional Coloring on Donut Chart based on value

Although this idea works, its not really working in my scenario. For example I have 2 measures in the values. One is the % value, and the other is the 'blank' value (eg. 1-%). See below;

I think with your example, it fixes the area of the chart fill, so any value between 80-100% fills the same amount of the chart area with the associated colour. I need it colour and fill acuratley by the %. So 45% fills 45%, and 47 % fills 47% of the chart. Let me know if this need clarifying further.

Thanks

Microsoft

## Re: Conditional Coloring on Donut Chart based on value

@rax99

It's better to show your sample file and expected output. You can upload it to OneDrive or Dropbox and post the link here.

Regards,

Cherie

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

## Re: Conditional Coloring on Donut Chart based on value

Hi, Cherie

Its just a simple table, and I need the colour of the donut chart to depend on the 'Average of Availability' value. So currently its 87.34% so this would be shown as green. However if this was <70% it should be Yellow, and if < 50% then Red.

Hope this helps.

Microsoft

## Re: Conditional Coloring on Donut Chart based on value

Hi @rax99

It seems it's not supported on Donut Chart currently. You may vote or post your comment for this similar idea. How about using Conditional formatting in tables or using condition format on column chart. Here is the reference for you and hope it can help you.

Regards,

Cherie

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

## Re: Conditional Coloring on Donut Chart based on value

Hi Cherie,

I will consider your suggestion. However, thank you for all your time and help on this topic.

Announcements

#### Coming Soon: T-Shirt Design Contest

Keep your eyes open for our upcoming T-shirt design contest!

#### Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

#### Super User Challenge: Can You Solve These?

We're celebrating the start of the New Super User season with our first ever Super User 'Can You Solve These?' challenge.