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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
CH_MJR79
Helper II
Helper II

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.

CH_MJR79_0-1708609091061.png

 

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 

 

1 ACCEPTED SOLUTION
Syk
Super User
Super User

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.

View solution in original post

2 REPLIES 2
Syk
Super User
Super User

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.

Jackpot. Many thanks @Syk.

 

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

CH_MJR79_0-1708613348513.png

 

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.