cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
rax99 Member
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 v-cherch-msft
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:

 

1.png

 

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.
rax99 Member
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 v-cherch-msft
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.
rax99 Member
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;

 

 donut.JPG

 

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 v-cherch-msft
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.
rax99 Member
Member

Re: Conditional Coloring on Donut Chart based on value

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.

Microsoft v-cherch-msft
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.
rax99 Member
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. Smiley Happy

Helpful resources

Announcements
Coming Soon: T-Shirt Design Contest

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!

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?

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.

Power Platform Online Conference

Power Platform Online Conference

Join us for the first ever Power Platform Online Conference!

Top Solution Authors
Top Kudoed Authors