Line break in line chart

Hi weilai0521 ,

Follow the steps below, then it will return the result you desired.

1.Set the X axis type to "Categorical" instead of "Continuous", which will make the "Show marker" button available.

2.Turn on the "Show marker" button .Select the Marker shape you prefer from the drop down. For further customization => Turn On => Customize Series or other  Customize shapes, size, color and so on.

Best Regards,

Amy

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

I really appreciate the help. 

I tried the categorical option but it gives me a graph like this. The year order mess up. Is there a solution for that? I tried to create a year_order variable and sort the year by year_order, which does not solve the problem. 

Thanks!

Hi weilai0521 ,

When I create the Year column from formula Year = YEAR(Sales[DateKey]), I can reproduce your scenario. I worked around this issue following steps below.

While if you get the Year column from a date field, it won't have the issue.

Best Regards,

Amy

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.