Forum Discussion
cv2qm
Helper I
Helper ISet default Today in Slicer date and also select date
Hello community, I am implementing a date picker in slicer. I achived that by using 'before' option in slicer, and wrote DAX measure to bring selected date related value. Calender table has dat...
- cv2qm
It's not currently possible to have both date picker and relative date option, nor is it possible to set a relative default (like today) for a slicer.
https://ideas.powerbi.com/ideas/idea/?ideaid=0eab4ba7-b039-4785-9414-b8c94ab06e25
amitchandak
Super User
Super Usercv2qm , there is way initialize on a function like today.
You can have a column like this in you date table sorted on date and use that to filter today
Date Type = SWITCH(TRUE(),'Date'[Date]=TODAY(),"Today"
,'Date'[Date]=TODAY()-1,"Yesterday"
,'Date'[Date]=TODAY()-2,"2 Days Ago"
,'Date'[Date]&"")
In case you need more than a day data when you select only today -