Forum Discussion

johnmelbourne's avatar
johnmelbourne
Helper V
6 years ago
Solved

X axis date format and interval

This is my current X axis, and I want it to be Sep-18   Dec-18   Mar-19   etc which align with the data points.

It is using a calculated field which is 

MMM-YYYY = FORMAT([Date],"MMM-YYYY")
 
Any idea how to get the month interval to 3 from 2?
 
 
Thanks
 
 
Need Help
  • v-gizhi-msft's avatar
    v-gizhi-msft
    6 years ago

    Hi,

     

    According to your description, i think the X-axis interval in Line Chart is automatic.

    And i have a workaround for you.

    You can try to shrink your visual and it shows three month intervals:

    Hope this help.

     

    Best Regards,

    Giotto Zhi

1 Reply

  • v-gizhi-msft's avatar
    v-gizhi-msft
    Community Support
    6 years ago

    Hi,

     

    According to your description, i think the X-axis interval in Line Chart is automatic.

    And i have a workaround for you.

    You can try to shrink your visual and it shows three month intervals:

    Hope this help.

     

    Best Regards,

    Giotto Zhi