Sort week on year

[Flavio2021]

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

[lbendlin · Accepted 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).

[Flavio2021 · Accepted solution]

Thank you for the suggestion

[Flavio2021]

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

[lbendlin]

You need to use a proper calendar table if you want the dates.

[lbendlin · Accepted 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).