Hello.
I download a database and get the WorkWeek with power query since I want to sparlines the presentation by WW.
When pivoting the data, the table is sorted by WW as a number and not a date. How can I sorte according to date if I don't need to use the date in the table?
Many thanks, Bruno.
Attached is the data and one sentence explanation.
Hi Bruno,
Change the week number format to yyyy_mm as text i.e. January 2020 looks like this: 2020_01. The zero in front of the 1 is important for the sort order. This way it should sort in the correct order.
Mynda
From some reasons, my file didn't want to follow the definition of that new column and despite the fact I saw it was ordered the correct way and it was defined as text, the file decided to use the old version when I was pivoting the table. Only when I deleted the old table I waas not using anymore from PQ, I was able to get it correctly.
Works fine, than you.
Bruno
