Forum Discussion
Post PartisanNeed help to build function - Paypal donut chart
Dear all,
I have below chart to indicate the percentage of increase/decrease.
I want the chart to show green when the percentage is negative and red if the percentage is positive. And the length of the color represent the absolute value of percentage. Eg. For -10% and 10%, the graph should look the same just the color is difference.
Thank you!
3 Replies
xiumi_houUP
v-joesh-msftSolution Sage
Hi xiumi_hou ,
Based on my research, using circle-KPI-gauge may not achieve the results you want. I tried another method, approaching the results you want and hoped to help:
1. Create a new measure and select the gauge chart：
Measure 2 = VAR temp = CALCULATE ( SUM ( 'Table'[amount] ), ALLEXCEPT ( 'Table', 'Table'[name] ) ) RETURN IF ( temp < 0, ABS ( temp ), temp )2. Select Format-Data colors-Conditional formatting
3. Setting conditions
Results are as follows:
Here is a demo, please try it:
Best Regards,
Community Support Team _ Joey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Is this option still not available on this visual?
