Forum Discussion
Start horizontal scroll from current week
amitchandak When you say select this week always, where should the selection be made? How do we select that in matrix.
Also, by the solution below what I understand is that my column values in matrix would now be week dates and a text value as 'This week' right?
Super UserAnonymous , 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
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
- amitchandak
Anonymous , Is this idea what you need
https://ideas.powerbi.com/ideas/idea/?ideaid=94e64b87-c920-4515-9104-614be64065db
Please vote
Yes, pretty much on those lines. Thank you