Looking for a single date slicer

[jacccodezwart]

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

[danextian]

Hi @jacccodezwart

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.

[ryan_mayu]

@jacccodezwart 

so 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

[Kedar_Pande]

@jacccodezwart 

Slicer (List) → [Date] → Format → Selection controls → Single select ON

One date selectable at a time

[jacccodezwart]

Allmost, 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 · Accepted solution]

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

[Xian-Zuo]

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:

：