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 seem to find this option anywhere. Is there something obvious im missing?

Need Help
Tutorial Requests

8 Replies

  • v-cherch-msft's avatar
    v-cherch-msft
    Microsoft Employee
    7 years ago

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

      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