Forum Discussion
PowerBINoob24
Resolver I
Resolver ILine 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 ...
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.
amitchandak
Super User
Super UserPowerBINoob24 , 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