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
cv2qm
You can create another column in the calendar table to get the date from the beginning to today. Then use 'Before' option in the slicer.
Date-Today = IF([Date]<=TODAY(),[Date])
Paul Zheng _ Community Support Team
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
cv2qmHelper I
Helper I1. I want to show report default for today everytime.
2. User can pick any date if he/she want to search.
But in your case it will always show today's date.
- AllisonKennedy
Community Champion
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