Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
coochy5
Helper II
Helper II

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

 

coochy5_0-1734975306538.png

 

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

 

coochy5_3-1734975983243.png

 

 

 

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.

coochy5_2-1734975732576.png

 

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

1 ACCEPTED SOLUTION
DataInsights
Super User
Super User

@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 





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




View solution in original post

2 REPLIES 2
DataInsights
Super User
Super User

@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 





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




excellent !  Many thanks !

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.