Incorrect data label position with two values

Question

This is a Line Clustered Column Chart where the Markertype of the line Values are changed to dots.The problem can be seen with group 2. The data points are correct. Unfortunately, the data labels are not correct. 28.03% should be at the top and 25.10% should be below.&nbsp;I have set the position of the datalabels for "B actual Year" and "B last year" to "Auto". This way the datalabels are set automatically by Power BI.&nbsp;Unfortunately, it does not help to set "B actual Year" to "Above" and "B last Year" to "Below", because it can happen that the data point for "B actual Year" is higher in one group and lower in the other group than the data point "B last Year" (see in group 2 and group 4).It is also useless to set the position of both datalabels to "above" or "below", because otherwise the datalabels would overwrite each other. So one of the two datalabels would no longer be visible.&nbsp;If I drag the chart larger, the datalabels are correct again. Unfortunately I can't make it bigger on my dashboard and therefore I'm looking for a solution how to make the datalabels with a lower value than the other one stand at the bottom and the datalabels with a higher value stand at the top.

matinemr · Answer

Unfortunately, it does not help to set one measures to "Below" and the other to "Above", because it can happen that the data point for "B actual Year" is higher in one group and lower in the other group than the data point "B last Year" (see in group 2 and group 4).&nbsp;This means that for one of the two groups, the data label of these Measures would again be positioned incorrectly.

wilkerfrl94 · Answer

This is totally unsettling with PowerBI "Auto" positioning of labels.&nbsp;It should be OBVIOUS that with only 2 series, being a higher and a lower value, the labels should be above and below based on such values. Also BI doesn't let you manually fit each label as higher or lower, which is just awful when making line charts showing 2 series of data, like comparing between years.&nbsp;Just makes it hard to understand which is the higher value, also sets labels over data points where it should not be needed.&nbsp;Wish they could make this little improvement. Sure it's something based on especific cases of data, but i wonder how much people have this same problem and just deal with it as "oh, this is something PBI can't solve i guess".

amitchandak · Answer

MatinEmr , There is an option to change the label position. Go and choose to customize series and for both lines, choose measure and set it below or above. Do not leave auto

anonymous · Answer

Hi&nbsp; MatinEmr&nbsp;,
&nbsp;
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
&nbsp;
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

jaymeowmeow · Answer

Did you ever find a solution? This is bothering the crap out of me, too! But if I try to put one above and one below, there are MORE issues depending on the filter/slicer my visual is set to (various departments/divisions).&nbsp;

Forum Discussion

Related content

Measure returning incorrect value

KPI showing incorrect target value

Stacked Column Chart Displays Incorrect Total Values After Adding Legend

YOY change incorrect when prior year value is negative

Parameter (decimal) resolving to incorrect value