Conditional Coloring on Donut Chart based on value

[Anonymous]

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?

[v-cherch-msft]

Hi @Anonymous

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

Regards,

Cherie

[Anonymous]

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

[v-cherch-msft]

Hi @Anonymous

Here is the file.

Regards,

Cherie

[Anonymous]

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

[v-cherch-msft]

@Anonymous

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

[Anonymous]

Hi, Cherie

see link: PBI File

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.

[v-cherch-msft]

Hi @Anonymous

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

[Anonymous]

Hi Cherie,

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