How to filter both Date and Time range from timestamp column

[sharmisaranga09]

I have app insights data with timestamp column in it. Need to create a powerbi report with timerange filter where user needs to pick from /to date and from/to time. I can get start date and end date by using slicer setting 'between'. As for the time range I couldn't get the expected

I am trying to acheive something like this

[Idrissshatila]

Hello @sharmisaranga09 ,

there's no between slicer that will show between date and time, you have have them as a drop down.

[sharmisaranga09]

Dropdown of whole timestamp or is it possible to split date and time and have dropdown for date separately and dropdown for time separately?

Even if I get them separately I couldn't set from/to limits to time part. 

[Idrissshatila]

Hello @sharmisaranga09 ,

yes, you need first to split the datetime column into two columns, date column and time column then you can add it in two seperate drill down slicers.

check this to split the datetime into date and time https://www.youtube.com/watch?v=RR5XvbRwCxI

[sharmisaranga09]

I got the date and time extracted into two columns, can I apply from and to on date and time or is it possible only through dropdown as you mentioned earlier?