Forum Discussion
Helper ILooking for a single date slicer
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
Super User
Slicer (List) → [Date] → Format → Selection controls → Single select ON
One date selectable at a time
Helper IAllmost, what I want is something that looks like this :
. . . and when I move the button, the date changes by one. When move left, go back in time and move right, go to future.
- v-dineshya
Community Support
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
- jacccodezwart
Thanks for your sugestion !!
I will look in to it.
Jacco
- v-dineshya
Hi jacccodezwart ,
Thank you for the update. Please provide ETA (Estimated time for arrival ) for this thread.
Regards,
Dinesh
First, to achieve the effect shown in your diagram, it must be a numerical range parameter. Currently, Power BI only supports numerical ranges to enable single-value options. Therefore, we must indirectly convert dates into numerical values. Since the numbers need to resemble dates, we can use the yyyyMMdd format. Within the format string, entering 0000/00/00 ensures the integer is displayed as yyyy/MM/dd without altering the integer's format. Here's the specific approach:
：
