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.

pk1593's avatar
pk1593
Helper I
3 years ago

Thank you v-jianboli-msft  for the revert. But this is only giving red/green colour to up/down arrow in the table and not in the column chart.

 

What I'm looking for is up/down arrow in the chart itself along with the data label. 
for eg: in the coloumn chart for time period Q1 - I need the data label to be "33% ↑" for B and "33% ↓ " for C in the data label itself (This functionality is available in Tableau)