Date format for matrix calendar - issues

coochy5 — Mon, 23 Dec 2024 17:47:20 GMT

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) ?

Re: Date format for matrix calendar - issues

DataInsights — Mon, 23 Dec 2024 18:17:29 GMT

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

coochy5 — Mon, 23 Dec 2024 19:04:16 GMT

excellent ! Many thanks !