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

[Anonymous]

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.

[Anonymous]

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.

[Greg_Deckler]

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