Forum Discussion

coochy5's avatar
coochy5
Icon for Helper II rankHelper II
1 year ago
Solved

Date format for matrix calendar - issues

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