Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Learn more
 
					
				
		
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...)
Any idea how I can achieve this and just showing the days (dd/mm)?
@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
 
					
				
				
			
		
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Check out the October 2025 Power BI update to learn about new features.
 
            | User | Count | 
|---|---|
| 85 | |
| 49 | |
| 36 | |
| 31 | |
| 30 |