Get certified for free when you join Fabric Data Days 2026 and dive into Fabric, Power BI, SQL, AI, and other essential data skills.
Join nowTry your skills in the Power BI Dataviz World Championship! Round one ends June 26. Join now
Hi team
I have tried to replicate the suggestion in the forum about how to sort correctly the week when there is a change of year, but every time I drop in the message that I have no unique value for sorting correctly with Sor by another column function
Can someone help me and rephrase the solution using also my file. Could be probably the best way for me to understand
File PIbix reportship.pbix
Here the wrong result I get
Solved! Go to Solution.
See attached. You don't have enough screen space to put in the date format (unless you use SVG to turn the label sideways).
Thank you for the suggestion
Ouch ! think easy ! yes good suggestion. Can you kindly share if you know, how to have instead of the week number the week in a format dd/mm/yy (on monday or sunday) ...in meantime I am go to read something more about SVG to turn the laberl
Looking for yor input and thank for the help
You need to use a proper calendar table if you want the dates.
Don't miss out on Data Days, June 15 through August 7. Learn Fabric, Power BI, SQL, AI and more.
Check out the May 2026 Power BI update to learn about new features.
| User | Count |
|---|---|
| 22 | |
| 22 | |
| 21 | |
| 20 | |
| 12 |
| User | Count |
|---|---|
| 58 | |
| 55 | |
| 41 | |
| 36 | |
| 35 |