Single date input in Power BI

[vivek_babu]

Hi,

I am trying to convert a spotfire dashboard to Power BI. We have a input field in Spotfire which takes datetime as the filter value so users type the required date in the input field then there is a calculation happens based on the date entered by the user. I need to do the same thing in Power BI but here the slicer does not take single date as an input so how to solve this issue? 

Please let me know your solution

@Ritaf1983 @amitchandak @rohit1991 @danextian @burakkaragoz @Akash_Varuna @FBergamaschi @Elena_Kalina @Ashish_Mathur @pankajnamekar25 @mark_endicott 

[danextian · Accepted solution]

Hi @vivek_babu 

Power BI doesn't currently support single date selection unless you're using a dropdown or tile slicer.   My usual workaround is to use a before option of the range slicer, a shape and a text box. The shape and textbox cover the min date of the slicer. They're then grouped and I ensure that maintain layer order is enabled for those three visuals

[v-aatheeque · Accepted solution]

Hi @vivek_babu 

To meet your goal allowing users to pick a single date easily (not from a scrollable range slicer), but through search or direct input you can use a slicer with dropdown

Try this below steps :

•  Add your date field to a slicer.
• In the slicer settings >> slicer visual>> More options.
• Choose “Dropdown” instead of “Between” or “List”. Click on the slicer where the dates are shown on your report.

Reference :   https://databear.com/power-bi-on-screen-date-picker-no-custom-visual/
                    https://www.youtube.com/watch?v=zhWtU0DynCk&t=585s

Hope this helps !!

Thank You..

[kushanNa]

hi @vivek_babu 

Have you checked Patrick's Single date picker method to see if it works for you?

https://www.youtube.com/watch?v=zhWtU0DynCk&ab_channel=GuyinaCube 

[vivek_babu]

Hi @kushanNa 

Thanks for the response. I tried this after and before approach but i need the selected date alone. Example if i pick 7/30/2025 and i use selectedvalue function then it needs to return the exact date. This is not happening with min or max approach.

Regards

[kushanNa · Accepted solution]

Hmm, interesting. Is it possible for you to provide us with a sample scenario a PBIX file or a screenshot using some dummy data that you're facing the issue with? Also, have you used the TREATAS function in your scenario, like in Patrick's video? It seems that this function helps perform calculations for that specific date

[vivek_babu]

Hi @kushanNa 

I tried using patrick's approach. I used After style option in the slicer and then created measure like this,

DatePick =

var _selecteddate = MIN('Calendar Table'[Date])

RETURN

_selecteddate

This works and it provides me the date that is selected in the slicer. Thanks for your help

Regards

[danextian · Accepted solution]

Hi @vivek_babu 

Power BI doesn't currently support single date selection unless you're using a dropdown or tile slicer.   My usual workaround is to use a before option of the range slicer, a shape and a text box. The shape and textbox cover the min date of the slicer. They're then grouped and I ensure that maintain layer order is enabled for those three visuals

[vivek_babu]

Hi @danextian 

I tried using patrick's approach. I used After style option in the slicer and then created measure like this,

DatePick =

var _selecteddate = MIN('Calendar Table'[Date])

RETURN

_selecteddate

This works and it provides me the date that is selected in the slicer. Thanks for your help

Regards

[vivek_babu]

Hi @danextian 

Thanks for the response. I tried this after and before approach but i need the selected date alone. Example if i pick 7/30/2025 and i use selectedvalue function then it needs to return the exact date. This is not happening with min or max approach.

Regards

[vivek_babu]

Hi @FBergamaschi ,

Thanks for quick response.

Yes i have a date table and if i use this in slicer then it provides me the between range like start and end date which i dont need. I need single date selection by the user not the date range

Regards

[FBergamaschi]

The user will have to do a selection on those dates, or am I missing what you are trying to do. How does yhe user selects the date? Does this happen outside Power BI? Is this selected date available in a table?

[vivek_babu]

Hi @FBergamaschi ,

It is a input field in spotfire like a what if parameter in power bi. Users will type the required date in that field and that date is fetched and used in the calculations.

Regards

[FBergamaschi]

Ok do if that selection is available in a table in power bi that is easy,  otherwise I do not see solutions

[vivek_babu]

Hi @FBergamaschi 

I have dates in a table only problem is i need to put this field in a slicer and allow users to select single date instead of the date range. Then i can use selectedvalue function to capture the user selected date and use it in my calculations 

Regards

[FBergamaschi]

Will not a "list of values" slicer with single section do?

[vivek_babu]

Hi @FBergamaschi 

It will work but users dont want to scroll and select dates manually instead they prefer either search option or directly input the dates

Regards

[v-aatheeque · Accepted solution]

Hi @vivek_babu 

To meet your goal allowing users to pick a single date easily (not from a scrollable range slicer), but through search or direct input you can use a slicer with dropdown

Try this below steps :

•  Add your date field to a slicer.
• In the slicer settings >> slicer visual>> More options.
• Choose “Dropdown” instead of “Between” or “List”. Click on the slicer where the dates are shown on your report.

Reference :   https://databear.com/power-bi-on-screen-date-picker-no-custom-visual/
                    https://www.youtube.com/watch?v=zhWtU0DynCk&t=585s

Hope this helps !!

Thank You..

[vivek_babu]

Hi @v-aatheeque 

I tried using patrick's approach. I used After style option in the slicer and then created measure like this,

DatePick =

var _selecteddate = MIN('Calendar Table'[Date])

RETURN

_selecteddate

This works and it provides me the date that is selected in the slicer. Thanks for your help

Regards

[vivek_babu]

Hi @v-aatheeque 

Thanks for the response. I tried this after and before approach but i need the selected date alone. Example if i pick 7/30/2025 and i use selectedvalue function then it needs to return the exact date. This is not happening with min or max approach.

Regards

[FBergamaschi]

Power BI can only wirk on tables, so you must create a list of all the dates and create a slicer on that

You already have a calendar table?