Forum Discussion

espo4life's avatar
espo4life
Helper I
6 years ago

X-Axis Date Forematting

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

Need Help

2 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    6 years ago

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

  • V-lianl-msft's avatar
    V-lianl-msft
    Community Support
    6 years ago

    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.