Forum Discussion
Solved
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 ...
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.
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.