Forum Discussion
Can anyone help with this Line Chart Issue?
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.
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.