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!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! 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
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 65 | |
| 43 | |
| 41 | |
| 33 | |
| 23 |
| User | Count |
|---|---|
| 199 | |
| 124 | |
| 104 | |
| 74 | |
| 55 |