Selecting default - week value dynamically

[Anonymous]

Hello,

Have a week slicer and need to select the week value automatically when the last week changes to current week and current week changed to next week - dynamically.

The week slicer has to pick the current week by default and it has to change dynamically when we move to next week.

for example - The week start from Sunday - saturday(30-07-2023 To 05-08-2023) slicer has to pick this week as default and this week has to be selected/checked automatically.

If calendar moves to next week i,e. (06-08-2023 To 12-08-2023) - then week slicer have to changed to this week automatically.

Any advices/ideas how can achieve this scenario in Power BI

Thanks in advance.

[Anonymous · Accepted solution]

Hi  @Anonymous ,

Here are the steps you can follow：

1. Then we find the "Preselected Slicer" and add the visual to our Power Bi Desktop.

2. First , we need to create a table with one column , and the value is True and False,.

3. Second , we can create a measure to define which the date we need to default preselected. If we need to default preselect then we return True else return False.

Flag =
var _date =SELECTEDVALUE('Table'[WEEK])
return
IF(_date = WEEKNUM(TODAY(),2) , TRUE(),FALSE())

4. Then we can put the 'Table'[Date] in the Fields , [Flag] in the Pre Selection , 'Dirty Table'[Dirty Status] in the Dirty Status, like below screenshot:

5. Result:

Best Regards,

Liu Yang

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

[amitchandak]

@Anonymous , You have to create this column in date tbale and save on this week or last week

Week Type =
var _st = today() +-1*WEEKDAY(today() ,1)+1
var _end = today() + 7-1*WEEKDAY(today(),1)
return
Switch( True(),
[Date] >= _st && [Date] <= _end ,"This Week" ,
[Date] >= _st-7 && [Date] <= _end -7,"Last Week" ,
[Week Name]
)