Forum Discussion
Helper ILooking for a single date slicer
Hi all,
I don't know if this sub-forum is the right place to ask, if not I'm sorry.
Anyway, what I'm looking for is a date slicer (or settings for the current PBI date slicer) that has ONE button and if you move the button back and forth, just ONE date is selected from the related table. By doning to you select one date at a time.
Does such a thing exist ?
Thanks in advance.
Jacco
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
9 Replies
- Kedar_Pande
Super User
Slicer (List) → [Date] → Format → Selection controls → Single select ON
One date selectable at a time
jacccodezwartAllmost, 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
ryan_mayuso far, I don't think the default date slicer can meet your requirement. You can change to dropdown or list mode if you only want to select one date. What's more, if your date range is very huge. It's not easy to use the range slicer to select one specific date.
- jacccodezwart
I'm aware that on a large range, performance can be slow. But you can minimize that using (visual) filtering
- danextian
It looks like what you’re after isn’t available. I’ve seen several calendar custom visuals, but none offer buttons to move to previous or next dates—only a dropdown or a vertical single-select slicer provides that functionality sans the buttons.
