cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

Data points on a line chart do not connect when you have multiple values you wish to plot

I have two years of weekly data (so i get data once per week for the last two years) and its plotted by Date. I set up the line chart so that its year over year instead of year after year (left to right).

 

2018's data points were all connected but once 2019 began overlapping 2019, the data points are no longer connected. Instead of a line, they are just dots. 

 

After much research i havent found a way to keep the 2018 data points connected to each other and the 2019 data points connected to each other. It seems like because there are breaks in the data (because ites weekly and not daily), there is no way to keep them connected.

Has anyone else run into this issue and were you able to resolve it?

4 REPLIES 4
Highlighted
Super User IV
Super User IV

Re: Data points on a line chart do not connect when you have multiple values you wish to plot

Is your x-axis categorical or continuous? What if you use your Year as a Legend so that you get 2 separate lines?


---------------------------------------

Putting square pegs in round holes since 1972.

I have a NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Highlighted
Frequent Visitor

Re: Data points on a line chart do not connect when you have multiple values you wish to plot

I have tried using Year in the legend field with a single value in the Values field... I have also tried using an empty legend field and two value fields (2018 and 2019). They both looked exactly the same when plotted (broken once they begin overlapping).

 

I remember at one point having the option on the X axis to pick Categorical or Continuous, but for some reason it is no longer showing up as an option (its not even greyed out, it just doesnt exist as an option). Does anyone know why that option would be removed from the X Axis list? (its not in the Y axis option list either)

Highlighted
Super User IV
Super User IV

Re: Data points on a line chart do not connect when you have multiple values you wish to plot

Any way you can provide example/sample data to replicate?


---------------------------------------

Putting square pegs in round holes since 1972.

I have a NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Highlighted
Frequent Visitor

Re: Data points on a line chart do not connect when you have multiple values you wish to plot

I created a sample data set and a sample powerBI project but im not sure how to upload it to the thread. Help?

Helpful resources

Announcements
Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Using the Community

Using the Community

Need help with the Power BI Community? Our 'Using the Community' support articles are a great place to start.

Community Summit North America

Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Power Platform 2020 release wave 2 plan

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors