Data need to be searched based on Date and TIme

[hari1234]

Hi All,

Date and time is available as one column and the same i used as slicer to find the information but i am able to search based on Date .

Requirements is data need to search based on Date and Time stamp. Please let me know how to fix the problem

[v-henryk-mstf]

Hi @hari1234 ,

Currently, the Slicer does not support Time Slicer at time-level that you want to display. I did the following test: I created two separate lists of Date and Time in the Date/Time column, and then used Slice. For Date column, Slicer in the form of “between” is supported, while Time column does not. But it supports Slicer in the form of “list”.

Here is the sample pbix file.

Best Regards,
Henry

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak · Accepted solution]

@hari1234 , One of the option is have two columns date part and time part ans use slicer on those

Date = [Datetime].date

time =[datetime].time

also check

https://community.powerbi.com/t5/Community-Blog/Advanced-Time-Line-Slicer-Sorting-data-by-shifts-up-...