Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
Hi @rax99
You may try to add a column with IF condition. Then use 'Data colors' to show the color. For example:
Regards,
Cherie
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
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
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
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.
Hi @rax99
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
Hi Cherie,
I will consider your suggestion. However, thank you for all your time and help on this topic.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
99 | |
80 | |
70 | |
59 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |