datetime slicer

[jinma78]

I am looking to do a start and end datetime filter for my powerbi report but this is not as straight forward as I would have thought.  Basically, I just need to provide start date with start time in hours:min:sec and do the same for the end date.  The result of this should filter a table which has a column "datetime" type.  Anyone can suggest how this can be acheived?  I couldn't use the date slicer, but it only has date but no time.  I tried to add individual drop down selection for hh:mm:ss but ran into issue with using start and end datetime as range filter.  I would appreciate a detail explanation on how this can be accomplished.  Thank you in advance.

[v-jiascu-msft]

Hi @jinma78,

There could be a solution and a workaround. Please download the demo from the attachment.

1. Using the custom visual "Time Brush".

2. Add a column and convert the datetime to seconds. Finally, you can use range slicer.

Duration.TotalSeconds([DateTime] - #datetime(1970, 1, 1, 0, 0, 0))

Best Regards,

[jinma78]

This is not exactly what I was looking for as I need the user to be able to select date with hh:mm time resolution and specify start and end datetime.  something like this https://powerusers.microsoft.com/t5/General-Discussion/Date-Time-Picker-Missing-Time/td-p/49940