Chart Dates Out of Order

[Jer Maine]

Good day, I am attempting to chart weekly data in the form of a bar chart. My data is in Power Pivot. I am using a Date Table linked to my Fact table on a field called DateInt which is a column of each day of the year formatted as an integer. The other column, WeekBeginning, is the beginning day of the that week formatted as a date.

My chart is sorting dates on the horizontal axis by the first number in the day of the month instead of actual date as follows:
5/27/2018 --- 6/10/2018 --- 6/17/2018 --- 6/24/2018 --- 6/3/2018

I have tried sorting the Pivot Chart field A to Z and by Data Source Order. Neither have worked. I have tried changing the Axis options axis type setting to Text and to Date Axis. Same result.

The sort does work correctly when I format the source data column as "General" instead of "Short Date". But I don't want to display the dates as:
43247 --- 43254 --- 43261 --- 43268 --- 43275

Any ideas? Thanks for any help you can offer.

 

[Keebellah]

Have you tried setting the format to year month day and then sort it?

 

[Jer Maine]

Have you tried setting the format to year month day and then sort it?

Okay, that does appear to be working. I've got my beginning day of the week column formatted like 20180625 for June 25, 2018 and so on. For whatever reason, though, the labels on the chart are formatted like 6/25/2018. I'd like them to be 6/25/18. The settings are being extremely finicky and don't appear to do anything even though I specified in Format Axis / Number / Category = Date and Type = 3/14/12. I also set Axis Type to Date axis.

Shouldn't that format it to the 6/25/18 style.

Thanks for your help!

 

[Keebellah]

Somewhere in the axis formatting you can set the date and number formats at will. It might differ a little depending on the Office version you're using, you'll get there