Slicer Dynamic Update - Weekwise

Anonymous , You can use a relative date slicer if that can work. Else create week column

 

Have columns like these in date table

 

Week Start date = 'Date'[Date]+-1*WEEKDAY('Date'[Date],2)+1

Week Number = WEEKNUM([Date],2)
Week Name= 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],,ASC,Dense)

 

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

 

Select this week and Save

 

Refer if needed

Default Date Today/ This Month / This Year: https://www.youtube.com/watch?v=hfn05preQYA&list=PLPaNVDMhUXGaaqV92SBD5X2hk3TMNlHhb&index=35

Hi, Anonymous ;

I tested it , Monday's 0:00 and Sunday's 23.59.59 also belong to this week.

 

and according to the video ,I create a simple data ,as follows:

1.create a column.

Is Week = IF(WEEKNUM([Date],2)=WEEKNUM(TODAY(),2),"This week",FORMAT([Date],"mm/dd/yyyy"))

2. then the final output is shown below:

Another method:

1. enter a table

2.create a flag measure.

flag =
SWITCH (
    SELECTEDVALUE ( 'slicer'[Slicer] ),
    "This month", IF ( EOMONTH ( MAX ( [Date] ), 0 ) = EOMONTH ( TODAY (), 0 ), 1 ),
    "This week", IF ( WEEKNUM ( MAX ( [Date] ), 2 ) = WEEKNUM ( TODAY (), 2 ), 1 ),
    "This day", IF ( MAX ( [Date] ) = TODAY (), 1 )
)

3.apply it into filter.

4. the final output is shown below:

Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.