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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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.

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.

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.

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

Top Solution Authors