Forum Discussion
Looking for a single date slicer
- 7 months ago
Hi jacccodezwart ,
Thank you for reaching out to the Microsoft Community Forum.
As you mentioned , when you move the button, the date changes by one. When move left, go back in time and move right, go to future. In Power BI, the built‑in Date slicer doesn’t provide a single‑knob slider that selects exactly one date. Its modes are Between two handles, Before, After and Relative all of which select ranges, not a single day.
Please try alternative workaround.
1. I have created sample data based on your requirement.
2. Created Calendar and Sales tables. And created "Date Selector" disconnected Date table.
3. Created Selected Date and Sales (Single Date) measures.
4. Drag the 'Date Selector'[Date] in slicer, 'Date Selector'[Selected Date] in table visual and 'Date Selector'[Sales (Single Date)] in column chart for testing.
5.In slicer settings, options --> Style --> Before(select the option).
Please refer below output snaps and attached PBIX file.
If you select "Before" option in settings, slicer visual displays only single date. if you move the slider to left , it will display past date. if you move the slicer to right , it will display future date.
I hope this information helps. Please do let us know if you have any further queries.
Regards,
Dinesh
Thanks for your sugestion !!
I will look in to it.
Jacco
Hi jacccodezwart ,
Thank you for the update. Please provide ETA (Estimated time for arrival ) for this thread.
Regards,
Dinesh