topic Sort Data By Week Number in Desktop

Sort Data By Week Number

Anonymous — Thu, 30 Jul 2020 08:09:02 GMT

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.

Re: Sort Data By Week Number

AllisonKennedy — Thu, 30 Jul 2020 08:16:37 GMT

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

Re: Sort Data By Week Number

amitchandak — Thu, 30 Jul 2020 08:22:59 GMT

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-Power-BI-Turning/ba-p/1187482