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
AllisonKennedy
Community Champion
Community ChampionYou can only use the built in relative date filters on the slicer, so if you are using 'before' you cannot set it to always be today. Do you ever need it to show future dates? You could add a filter to the slicer to only show dates in the past 3? 10? years so that it only goes until today?
cv2qmI just want to show today's date in sllicer always, if i can use relative date in filters how can i set slicer today's date always.
User can pick any date from Slicer.
Thanks!
Power bi doesn't support set default option in a slicer. However, there is a workaround that is possible by creating a measure to show today()'s data when nothing selected in the slicer, meanwhile you can select other dates in the slicer, please see the attached pbix.
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.