cancel
Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

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

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
PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors