Forum Discussion

xiumi_hou's avatar
xiumi_hou
Post Partisan
6 years ago

Need 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 t...
Need Help
xiumi_hou's avatar
xiumi_hou
Post Partisan
6 years ago

UP

  • v-joesh-msft's avatar
    v-joesh-msft
    Solution Sage
    6 years ago

    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:

    https://qiuyunus-my.sharepoint.com/:u:/g/personal/pbipro_qiuyunus_onmicrosoft_com/EbaYSN4d7VFHgjRtMJEgKJgBpYpDdM9NkwMShioTo6Zarg?e=AhCcDh

    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.