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

Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM. Register now.

Reply
Anonymous
Not applicable

Matrix columns with dates not showing in order

I have a matrix with Dates (dd/mm) as columns (the format is Text cause I didn't find any date format in powerbi that could correspond to what I needed). 

 

I want the dates to be ordered but without the need to add an extra row above it with the month it's in. The correct order below would be (27/02, 28/02, 01/03, 02/03...)

killjoy_0-1678187115415.png

 

Any idea how I can achieve this and just showing the days (dd/mm)?

killjoy_1-1678187125818.png

 

1 REPLY 1
amitchandak
Super User
Super User

@Anonymous , You can create a column and mark that sort column

 

Month day sort =  format([Date], "mmdd")

 

you now only need the year column if data is across the year

 

How to Create Sort Column and Solve Related Errors:
https://www.youtube.com/watch?v=KK1zu4MBb-c

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Helpful resources

Announcements
October Power BI Update Carousel

Power BI Monthly Update - October 2025

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

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Kudoed Authors