Help adding up/down arrow in chart

[pk1593]

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 table as a column(refer image below) but I want the up/ down arrow in the visual next to each data labels. 

Kindly help!

Please find link for the .pbix file here: Link for the .pbix file 

[v-jianboli-msft]

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]

@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. 

[v-jianboli-msft]

Hi @pk1593 ,

Sorry I misunderstood before.
According to my knowledge, the data labels for the 100% stacked bar chart are automatically generated and you can't set anything else for it, but you can consider adding Tooltips to this visual:

Final output:

For more details, please refer to:

Customizing tooltips in Power BI Desktop - Power BI | Microsoft Learn

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]

Thank you @v-jianboli-msft for the above.

In my case, I would require the arrow to be noticed first and then the numbers - so if I keep the label in tooltip everyone has to go through each data point to understand if it's up/down arrow.

Is their any way to add a text box/ card visual next to each no.  and it will show only arrows up/down as per the calculated measure next to each data point in the chart? For eg: in the coloumn chart for time period Q1 - a text box with "↑" will be present next to 33% for B and "↓" next to 33% for C (all the arrows will be filtered as per the time period & answer and calculated as per the measure) ? Is this possible? 

[v-jianboli-msft]

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]

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)