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
Anonymous's avatar
Anonymous
Not applicable
6 years ago

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'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