Forum Discussion

Naveen29's avatar
Naveen29
Helper II
10 months ago
Solved

PowerBI Dashboard Line chart

I would like to show datess ( Jan 2024, May 2025, Oct 2025 etc) on the x axis of line graph. but don't want to miss in between months data in the line graph. Sample line graph.    
  • v-sgandrathi's avatar
    v-sgandrathi
    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.