Forum Discussion
Line chart does not plot data between some points
I have a line chart visual that contains data for each month from 2024 to current, and it plots the lines perfectly. However, when I apply a filter to show certain months, it only partially applies the line plot. I have four line chart visuals on the page and they all do the same thing when I apply the filter...plot between the last three entries for 2024, but nowhere else. I can't figure it out for the life of me, as the months it does plot the line for are not continous, just like the rest of the graph. It seems pretty random to me. Does anyone have any thoughts or ideas why this might be happening and how to fix it?
Before filter
After filter
Hello PowerBINoob24,
Thanks for your followup.
The Type (Continuous / Categorical) option in the X-axis settings will only appear if the field on the X-axis is a date or numeric data type.From your screenshot, it looks like the X-axis might be using a text field (for example, “Month Name”). In this case, the Type option won’t be available.
To enable the setting:
- Ensure the field on the X-axis is an actual Date column.
- In Model view, check the Data type if it’s Text, change it to Date.
- Replace the current X-axis field in your visual with this Date field.
- Now, in the X-axis formatting pane, you should see the Type dropdown and be able to switch between Continuous and Categorical.
Best Regards,
Ganesh singamshetty.
9 Replies
PowerBINoob24 , This happens when there is missing data for in between months. As this is not a continuous visual (month on axis), it will show breaks andthe line will have breaks and that is why dots are shown, when we have missing months
Hi PowerBINoob24 ,
This is a very common issue in Power BI, and thankfully, it's an easy fix! The reason your line chart isn't connecting all the points is that your X-axis is most likely set to a "Continuous" type. When you filter out certain months, a continuous axis sees this as a literal gap in the timeline, so it breaks the line. The fix is to change the axis type to "Categorical". A categorical axis doesn't worry about the time between points; it just treats each month as a separate label and connects one to the next available one in your data, which is exactly what you want.
To make the change, you'll need to select your line chart visual. Then, go to the Format your visual pane, which is the one with the paintbrush icon 🖌️. Once there, expand the X-axis settings. You should see a dropdown menu for Type. Simply change this from Continuous to Categorical, and your chart line will connect across all the filtered points. You'll have to repeat this for each of the four charts.
Best regards,
This is all I get under the X-axis format. No option for type.
Hello PowerBINoob24,
Thank you for reaching out to the Microsoft Fabric Community Forum.I have reproduced your scenario in Power BI Desktop and confirmed the behavior you described when the X-axis field is set as a date and the Type option is available.
By switching the X-axis → Type from Continuous to Categorical, the line chart now connects all available months even after filtering out non-contiguous months, which matches your expected output.For your reference, I’m attaching the .pbix file.
Best Regards,
Ganesh singamshetty.
Hello PowerBINoob24,
Hope everything’s going great with you. Just checking in has the issue been resolved or are you still running into problems? Sharing an update can really help others facing the same thing.
Thank you.
Hello PowerBINoob24,
We hope you're doing well. Could you please confirm whether your issue has been resolved or if you're still facing challenges? Your update will be valuable to the community and may assist others with similar concerns.
Thank you.
Hello PowerBINoob24,
Could you please confirm if your query has been resolved by the provided solutions? This would be helpful for other members who may encounter similar issues.
Thank you for being part of the Microsoft Fabric Community.
