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 ,

 

To my knowledge, your requirement could not be realized currently. An idea similar with what you expect has been submitted in Microsoft Idea (powerbi.com), please vote it up and you can add comments.Hopes Power Bi will implement this in nearby future.

Besides, have you considered using a different color for the data labels instead of arrows? You can do it with conditional formatting:

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

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

    v-jianboli-msft  This would also work using conditional formatting for data labels.

     

    can you please check the conditional formatting forumula again. I think there is a mistake in showing the colour as per the up/down arrow in the table.