Power Pivot dd mmm yy sortable by date in the pivot table

[kcmuppet]

In the data model the data type is 'Date' and format is '14 Mar 01'. However in the pivot table the dates show as 'dd mm yy', and there is possibility at the 'Field settings...' to correct the format.

If I add a column to the data model with =FORMAT([Date], "dd MMM yy"), the pivot table shows the right format but then I can't sort by that date.

How can I get the date in the right format and preserve it's ability to be sorted?

 

[RoryA]

You can set a Sort by column for the formatted date column you added and specify to sort by the date column.