Forum Discussion
Helper IHow to filter both Date and Time range from timestamp column
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
4 Replies
- Idrissshatila
Super User
Hello sharmisaranga09 ,
there's no between slicer that will show between date and time, you have have them as a drop down.
sharmisaranga09Dropdown 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
