Forum Discussion

ericjo's avatar
ericjo
Helper III
1 year ago
Solved

Add increase/decrease marks to bar chart

I want to add an increase/decrease mark to the bar chart as shown in the following image. As you add, is it possible to change the dynamic color to green if the value increases and red if it d...
Need Help
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi, ericjo 

     

    You can try the following methods.

    Result = IF(ISBLANK([Measure%]),BLANK(),IF([Measure%]>=0,UNICHAR(9650)&FORMAT([Measure%],"Percent"),UNICHAR(9660)&FORMAT([Measure%],"Percent")))

     

    Color measure = IF([Measure%]>=0,"Green","Red")

    Result:

    Is this the result you expected?

     

    Best Regards,

    Community Support Team _Charlotte

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.