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

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

    • 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