Forum Discussion
Resolver ILine chart does not plot data between some points
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.
Super UserHi 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,
Resolver IThis is all I get under the X-axis format. No option for type.
v-ssriganeshCommunity Support
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.- PowerBINoob24
As noted in my screenshot above, I cannot find the setting to change to categorical. It's not there.
- v-ssriganesh
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.