Forum Discussion

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

Hi Anonymous

 

Here is the file.

 

Regards,

Cherie

Anonymous's avatar
Anonymous
Not applicable
7 years ago

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'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