Can anyone help with this Line Chart Issue?

[CH_MJR79]

Hi all,

I was wondering if I could get some assistance with a problem I'm having with a Line Chart, whereby the data points show as coloured dots, but there is no line connecting the dots.

I've created a file showcasing Sales, Cost of Sales, and Gross Profit for the years 2022 and 2023. However, I'm encountering an issue with the line chart visual.

Here's a quick rundown:

• I've set up a line chart to illustrate the increase in sales from 2022 to 2023.
• The X-Axis represents the Year, while the Y-Axis displays Sales totals for both years.
• Although the data points are visible, there's no line connecting them.

Here's a snapshot of the current chart - as you can see no line.

I've attached a link the .PBIX file containing dummy data.

Could someone kindly advise on where I might be going wrong and how to rectify this issue?

Thanks in advance for your assistance.

.PBIX and Dummy Data ZIP 

[Syk · Accepted solution]

It looks like you're using a measure to calculate each year individually. All you need is a measure that calculates your sales without the year specified.

[CH_MJR79]

Jackpot. Many thanks @Syk.

Now working perfectly further to changing it to a single Sales total measure.