Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

Reply
PowerBINoob24
Resolver I
Resolver I

Line Chart Data Labels Not Displaying Properly

I have a line chart with data labels being displayed, but in some cases the data labels are not displaying in the correct order. As you can see by the first data points on the far left, the red line should be 1.03% and the green line should be 2.29%, but they are reversed.  Then on the fourth data point from the left the 7.18% and 8.89% labels are reversed.  I've tried changing the position, changing the font size and anything else I can think of, but they won't display properly.  Any thoughts?line chart.PNG

1 ACCEPTED SOLUTION

When lines collide, there is no way to compare data ratios in a "spaghetti" type graph, as shown in the attached picture.
Trends are determined by their direction and slope. It is very difficult for our brain to understand the angle when there is another line on it and another number that you would like to add as a value.
I have attached an article on this topic.
First Example that they give  is a optiont that availible with small multiples of power bi.
https://www.storytellingwithdata.com/blog/2013/03/avoiding-spaghetti-graph
In any case, from a technical perspective, apart from the manipulations you attempted, the position of the values cannot be arranged.
Among the actions that can be taken are the maximum reduction in font size as well as the use of a "thin" font
"Calibry", for instance.
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Regards,
Rita Fainshtein | Microsoft MVP
https://www.linkedin.com/in/rita-fainshtein/
Blog : https://www.madeiradata.com/profile/ritaf/profile

View solution in original post

3 REPLIES 3
Ritaf1983
Super User
Super User

In this case, the tool is unable to handle the proportions of the values.
In addition, the graph in the picture is very difficult to read due to overlapping points, colors, and more.
Recommends that it should be broken down into small graphs using the functionality of small multiples.
Here is a link to a more detailed tutorial with a sample file (at my answer)
https://community.powerbi.com/t5/Desktop/Line-chart-with-different-lines-per-year/m-p/3189382#M10749...
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Regards,
Rita Fainshtein | Microsoft MVP
https://www.linkedin.com/in/rita-fainshtein/
Blog : https://www.madeiradata.com/profile/ritaf/profile

Unfortunately the requirement for the chart is that all lines need to be in the same graph so their relationship to each other can be easily seen.

When lines collide, there is no way to compare data ratios in a "spaghetti" type graph, as shown in the attached picture.
Trends are determined by their direction and slope. It is very difficult for our brain to understand the angle when there is another line on it and another number that you would like to add as a value.
I have attached an article on this topic.
First Example that they give  is a optiont that availible with small multiples of power bi.
https://www.storytellingwithdata.com/blog/2013/03/avoiding-spaghetti-graph
In any case, from a technical perspective, apart from the manipulations you attempted, the position of the values cannot be arranged.
Among the actions that can be taken are the maximum reduction in font size as well as the use of a "thin" font
"Calibry", for instance.
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Regards,
Rita Fainshtein | Microsoft MVP
https://www.linkedin.com/in/rita-fainshtein/
Blog : https://www.madeiradata.com/profile/ritaf/profile

Helpful resources

Announcements
Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors