Forum Discussion
Sort week on year
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
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
4 Replies
See attached. You don't have enough screen space to put in the date format (unless you use SVG to turn the label sideways).
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.
Thank you for the suggestion