Date format for matrix calendar - issues

[coochy5]

Hi all,

Not sure where to post this - so trying here first.

Not sure what I'm looking for is possible - tried all manner of formats and combos, without success.

Attempting to use a non-standard date format as a column, in a matrix visualisation.

Business wants days/dates displayed (and sorted) like so:

(Calender (old C# app) is displaying ddd-mmm only (and sorted appropriately))

In PowerBI - I can get a date to display (and sort) correctly, when I use a conventional date (as a date from date hierarchy)

Otherwise, when I try to use something like a custom format in the calendar 

("DM", FORMAT([Date], "ddd") & " " & Day([Date]) & "-" & FORMAT([Date], "mmm"))

I get a mangled result, and not able to apply a sort.

Is there a method to handle this ?

Also - if using/sorting a day#, would that spill over correctly (over a new year/leap year etc) ?

[DataInsights · Accepted solution]

@coochy5,

You can sort the custom date expression by the Date field in the same table.

https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-sort-by-column 

[coochy5]

excellent !  Many thanks !