Forum Discussion
PowerBINoob24
Resolver I
1 year agoLine 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 ...
- 1 year ago
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.
v-ssriganesh
Community Support
1 year agoHello 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.