X axis date format and interval

[johnmelbourne]

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

[v-gizhi-msft · Accepted solution]

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