Forum Discussion
Selecting default - week value dynamically
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.
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
2 Replies
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]
)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
