Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Start horizontal scroll from current week

Hi All, I have a matrix where my values are being showed on rows and on columns I have weekly dates which range from June to December and would still go ahead than that as well.   My problem is tha...
Need Help
amitchandak's avatar
amitchandak
Super User
6 years ago

Anonymous , Are you a week on the column and it coming ascending sort order.

To deal with you need sort it descending. The week column or a new column only for this Matrix.

 

Week Start date = 'Date'[Date]+-1*WEEKDAY('Date'[Date],2)+1
Week End date = 'Date'[Date]+ 7-1*WEEKDAY('Date'[Date],2)
Week Number = WEEKNUM([Date],2)
Week = if('Date'[Week Number]<10,'Date'[Year]*10 & 'Date'[Week Number],'Date'[Year]&'Date'[Week Number])
Week Rank = RANKX(all('Date'),'Date'[Week Start date],,desc,Dense)
Week name = [Week Start date] & " to "& [Week End date]

 

Whatever format you have for the week. make desc week rank as a sort column and use that

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

 

Anonymous's avatar
Anonymous
Not applicable
6 years ago

amitchandak thank you for your response, but I don't think that is what i am looking for. Let me just explain my requirement. 

 

Below snapshot shows how the matrix scroll works. It is always gonna start from the 1st week that i have in my data

 

 

Rather what i am looking for can be seen in the below snapshot, where now my matrix scroll will always start from the current week and if you see the scroller at the bottom, i can still go back and see historical weeks as well as future weeks. Whenever i open my report i would like to see my matrix in the below state.

Please let me know if this is possible