Forum Discussion

CH_MJR79's avatar
CH_MJR79
Helper II
2 years ago
Solved

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.

 

.PBIX and Dummy Data ZIP 

 

  • 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.

2 Replies

  • Syk's avatar
    Syk
    Resident Rockstar

    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's avatar
      CH_MJR79
      Helper II

      Jackpot. Many thanks Syk.

       

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