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?