Forum Discussion

pk1593's avatar
pk1593
Helper I
3 years ago

Help adding up/down arrow in chart

Hi,    I have created a measure which gives up/ down arrow as per a dummy condition. How to add this up/down arrow next to each data label in the coloumn chart? I can add the up/ down arrow in a t...
Need Help
v-jianboli-msft's avatar
v-jianboli-msft
Community Support
3 years ago

Hi pk1593 ,

 

Please try:

Label = IF([3.Percent]<[4.Percent_Previous],
IF(AND([3.Percent]-[4.Percent_Previous] <.05,[4.Percent_Previous]<>BLANK()),-1,0),
IF(AND([3.Percent]-[4.Percent_Previous] >.04,[4.Percent_Previous]<>BLANK()), 1,0))

Then conditional formatting [%]:

Final output:

 

Best Regards,

Jianbo Li

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