Forum Discussion
Slicer current date when open
hi all,
i tried folling to set the slicer at current date when open:
SlicerDate = IF(‘Table’[Date]=MAX(‘Table’[Date]),”Most Recent Date”,’Table'[Date]&””)
Power BI Tutorial: Dynamically update Date slicer to show Current Date – business intelligist
The problem is that i cant do any operations at the end because i have text format. I would like to see Today and the next 4 weeks. How can i modify the date column before that i only have Today and 4 Weeks that i can use in SlicerDate?
Many thanks for an idea.
Pikachu-Power , I think you should be able sort this column of date
Also, you can have a column for 4 weeks and use that visual level filter
Week Type =
var _st = today() +-1*WEEKDAY(today() ,2)+1 -28
var _end = today() + 7-1*WEEKDAY(today(),2)
return
Switch( True(),
[Date] >= _st && [Date] <= _end ,"Last 4 week" ,
[Week Name]
)
2 Replies
Pikachu-Power , I think you should be able sort this column of date
Also, you can have a column for 4 weeks and use that visual level filter
Week Type =
var _st = today() +-1*WEEKDAY(today() ,2)+1 -28
var _end = today() + 7-1*WEEKDAY(today(),2)
return
Switch( True(),
[Date] >= _st && [Date] <= _end ,"Last 4 week" ,
[Week Name]
)Yes youre right... I can use the Date instead of SlicerDate 😌 Thanks.
