Slicer current date when open

[Pikachu-Power]

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]

Yes youre right... I can use the Date instead of SlicerDate 😌 Thanks.

[amitchandak · Accepted solution]

@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]
)