Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

How to get current week selected on slicer with previous week options on loading report

Dear Team,

 

I have a data that is submitted weekly and saved in sharepoint list with every friday(weekdate). I want to show the utilisation dashboard based on the week submitted by default. I need to create a filter option for previous dates and defult date should be selected and based on the defult date remaining visuals should change by defult.

Need Help

2 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Icon for Community Champion rankCommunity Champion
    3 years ago

    Anonymous So most often this is done with a column that compares YEAR and WEEKNUM of a Date column with YEAR and WEEKNUM for TODAY. If they are the same, the row gets "Currrent Week". A value of "Previous Week" is given if the WEEKNUM is 1 off. You use this column in a slicer. Having a bit of trouble following exactly.

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi, I would like to add this image for refernce. every time when we open the report it should get select the last week as per image. is this possible in slicer or do i need to go to anyother visual to do this.