Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

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 s...
Need Help
Tutorial Requests
v-cherch-msft's avatar
v-cherch-msft
Microsoft Employee
7 years ago

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's avatar
Anonymous
Not applicable
7 years ago

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's avatar
    v-cherch-msft
    Microsoft Employee
    7 years ago

    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's avatar
      Anonymous
      Not applicable
      7 years ago

      Hi Cherie,

       

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