Forum Discussion
PowerBI Dashboard Line chart
- 10 months ago
Hi Naveen29,
Thanks you for followup Here’s the clear answer: in the standard Power BI line chart, you can’t manually select a few custom month ticks on the X-axis while keeping it continuous; the built-in label algorithm automatically picks which dates to display to avoid crowding. There are two main workarounds: (1) Use a proper Date table and a continuous Date axis, then add X-axis constant lines (via the Analytics pane) at your chosen dates (e.g., 2024-01-01, 2025-05-01, 2025-10-01) and set each constant line’s label to “Jan 2024”, “May 2025”, “Oct 2025”. This keeps all monthly data points and gives you the three visible “labels” as annotations, not axis ticks. (2) If you need to control the actual ticks, switch to a custom visual like Deneb/Vega-Lite or Charticulator, which lets you specify tick values directly while rendering the full monthly data. Other methods (like disconnected axis tables or category axes) will either remove intermediate months, break continuity, or still leave label selection to Power BI’s automatic logic. Let me know if you’d like instructions for setting up the constant lines or a sample Deneb spec.
Thank you
CST Member.
I tried all the options , but didn't work out. How to show the some custom dates range in the line chart of x axis?
- v-sgandrathi10 months agoCommunity Support
Hi Naveen29,
Thanks you for followup Here’s the clear answer: in the standard Power BI line chart, you can’t manually select a few custom month ticks on the X-axis while keeping it continuous; the built-in label algorithm automatically picks which dates to display to avoid crowding. There are two main workarounds: (1) Use a proper Date table and a continuous Date axis, then add X-axis constant lines (via the Analytics pane) at your chosen dates (e.g., 2024-01-01, 2025-05-01, 2025-10-01) and set each constant line’s label to “Jan 2024”, “May 2025”, “Oct 2025”. This keeps all monthly data points and gives you the three visible “labels” as annotations, not axis ticks. (2) If you need to control the actual ticks, switch to a custom visual like Deneb/Vega-Lite or Charticulator, which lets you specify tick values directly while rendering the full monthly data. Other methods (like disconnected axis tables or category axes) will either remove intermediate months, break continuity, or still leave label selection to Power BI’s automatic logic. Let me know if you’d like instructions for setting up the constant lines or a sample Deneb spec.
Thank you
CST Member.- v-sgandrathi10 months agoCommunity Support
Hi Naveen29,
Just wanted to follow up and confirm that everything has been going well on this. Please let me know if there’s anything from our end.
Please feel free to reach out Microsoft fabric community forum.- v-sgandrathi9 months agoCommunity Support
Hi Naveen29,
Just checking in -- have you had a chance to review and try the provided solution? Kindly share the status whenever you get a chance.
Looking forward to your response.