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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

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
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

April Fabric Community Update

Fabric Community Update - April 2024

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