Start horizontal scroll from current week

[Anonymous]

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 that Everytime my report is opened the matrix would show me the dates from June,  while this is ok as the current week is still being visible in the canvas, it would be a problem when my current week is further to the right and I always have to scroll to view that. What I am interested in is that whenever I open my report it should start from the current week. That way I have a liberty of scrolling to the left to view historical dates and if I scroll further right I can see my future dates.

I am not too sure if this is possible in Power BI, but if yes, then can someone please point a way out of it for me.

[Anonymous]

Hi @Anonymous ,

Please check if the workaround in the following thread can help you.

How to keep the scrollbar to the right in a power bi chart 

Best Regards

Rena

[amitchandak]

@Anonymous , Have a column like this in Date and week calendar

Week Type = Switch( True(),
[start week]<=Today() && [end date]>=Today(),"This Week" ,
[Week Name]
)

And select this week always

You can refer this how to get week start and week end

https://community.powerbi.com/t5/Community-Blog/Any-Weekday-Week-Decoding-Date-and-Calendar-2-5-Power-BI-Turning/ba-p/1187482

[Anonymous]

@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?

[amitchandak]

@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]

@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

[Anonymous]

Yes, pretty much on those lines. Thank you