Select always the current week within Slicer

Hi joshua1990 

Please correct me if I wrongly understood your issue .

You want to return the value of current week date and then through numbers in the slicer to filter the data . You can use TODAY() and WEEKNUM() to return the latest number .

(1)Create a column to get the week number of the date .

week number = WEEKNUM('Table'[Date])

(2)Create a column to judge the date whether belongs to the current week .

current week number = IF(WEEKNUM('Table'[Date])=WEEKNUM(TODAY()),1,0)

(3)Add a slicer with the field [week number] and put the [current week number] in slicer visual filters , set the value of the [current week number] to 1 .The current date is 09/14/2021 and week number is 38 ,so the return week number in slicer should be 38 .

(4)Select the number and filter the data you can see a result like this .Then you need to create again a column to determine whether the date is before the current date, in order to return the latest date belonging to the current week .

current date = IF('Table'[Date]<=TODAY(),1,0)

Put the [current date] in table visual filters and set it to 1 .The final result is as shown :

I have attached my pbix file , you can refer to it .

Best Regards

Community Support Team _ Ailsa Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.