Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredJoin 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.
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
Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!
Check out the October 2025 Power BI update to learn about new features.
| User | Count |
|---|---|
| 76 | |
| 37 | |
| 31 | |
| 27 | |
| 27 |