X-Axis Date Forematting

[espo4life]

I have a chart that is doing the following

but what I want is just the MMM DD to show on the x-axis (instead of MAY 18, 12 AM and MAY 18 12 PM, I just want one showing MAY 18). The ForecastDate column in a DATE field.

Thanks in advance!

Michael

[V-lianl-msft]

Hi @espo4life ,

Make sure that the field is in date format, and if the problem persists, try setting the type on the x-axis to category.

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Greg_Deckler]

So, is that field a Date field? You can change the format on the Column Tools or Measure Tools tab of the ribbon.