Forum Discussion

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

Tutorial Requests

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

Microsoft Employee

7 years ago

Hi Anonymous

Here is the file.

Regards,

Cherie

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

Related content