Showing proper dates in column chart

[MilwTed]

Each column is a week of sales.  I would like the X-axis to display the Sunday date from each week for each column.  Currently is just lists months.  The dataset has a Sunday date, and the sales info for that week.  So for example from the picture

05/01/22 - $29.6

05/08/22 - $37.5

etc

Getting PBI to display the months is the closest I can get.  Thoughts on how to fix this?

[HoangHugo · Accepted solution]

Hi

In the "X axis" edit, try to choose "Categorical"

[MilwTed]

Thanks, this worked.  Just a follow up -- I have the column set to short date format, but the chart still displays the long date.  Any idea how to get the chart to reflect short date?