Sort Data By Week Number

[Anonymous]

I have a bar graph in my PowerBI which I where I want the data sorted by week number. I have a calander table which allows me to do this but the data lables on the x-axis read 1,2,3 etc and I want them to say 1st Jan, 7th Jan, 14th Jan etc.

Do do I edit this so they have the date of the start of the week not the week number. 

[amitchandak]

@Anonymous , You create sort column

one of the two depends on do you have year no in week text

Week Start date = 'Date'[Date]+-1*WEEKDAY('Date'[Date],2)+1//Week start from Monday 
Week Number = WEEKNUM([Date],2) //Week start from Monday

Mark this a sort column : https://docs.microsoft.com/en-us/power-bi/desktop-sort-by-column

for Week calendar

https://community.powerbi.com/t5/Community-Blog/Any-Weekday-Week-Decoding-Date-and-Calendar-2-5-Powe...

[AllisonKennedy · Accepted solution]

Use the Start of Week option in Power Query if your calendar table is loaded as part of the model, then use Sort By Column function to sort the Start of Week column by Week Number column, and use the Start of Week column in the chart.
https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-sort-by-column