How to make weekly line chart show in date order, not alphabetical order

[MPetramalo214]

I have a line chart that uses rolling 90 days of data - now that there is a new year of data in the set though; the line chart shows this week at the front instead of the end.  I've tried sorting the column by date, but because there is more than one date per week; it won't let me.  Does anyone know of a way to sort this the way I need to?

Graph:

^ Notice how Week 0 is shown at the front of the graph, instead of at the end; where it falls in relation to the other dates

[amitchandak · Accepted solution]

@MPetramalo214 , you should sort week name on week start date

example

Week Start date = 'Date'[Date]+-1*WEEKDAY('Date'[Date],2)+1
Week End date = 'Date'[Date]+ 7-1*WEEKDAY('Date'[Date],2)

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

[amitchandak · Accepted solution]

@MPetramalo214 , you should sort week name on week start date

example

Week Start date = 'Date'[Date]+-1*WEEKDAY('Date'[Date],2)+1
Week End date = 'Date'[Date]+ 7-1*WEEKDAY('Date'[Date],2)

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

[MPetramalo214 · Accepted solution]

Our weeks start on Tuesday for all of our reporting - is there a way to make the formula reflect that?  I tried adjusting it to 'Date'[Date]+1-1*WEEKDAY('Date'[Date],2)+1 which makes it reflect that weeks Tuesday as the first day of the week; but still includes the previous weeks Monday.

[MPetramalo214]

Nevermind, I was able to figure it out! For anyone curious - change the Weekday formula to reflect WEEKDAY('Date'[Date] -2)