Formatting Date to "Fri 21"

[ElliotP]

Morning,

I have my date table, a date column in my data table and I'm trying to have appear on my x-axis "Fri 21" instead of having the full date from the date column or having to use the date from my data column.

I've tried FORMAT but I'm unable to get it to properly sort. I'm unable to change the format and type under modelling or edit in query editor to achieve the format I'd like.

Thoughts?

[BhaveshPatel]

You can try using the methods shown here uisng FORMAT function:

https://msdn.microsoft.com/en-us/library/ee634398.aspx

or 

Create a day column in your table using the FORMAT function and Combine the Day Part and Date Integer to get the desired results.

[ElliotP]

Thanks for the response. I've done that; but when you try to use that on a graph it doesn't show the dates in the correct order (for eg; Thurs the 20th is after Friday the 21st) like in my picture.

You can't convert the FORMAT'd column into a date as it errors out. Thoughts?

[ElliotP · Accepted solution]

The best way I've found to do it is;

DayDate = FORMAT('ExtendedCalendar'[DateKey].[Date], "ddd d")

To format my date the way I'd like. Then Sort the Column by "Day of Month".