Time of Day Slicer


#1

Hi,

I have currently got data which contains date and time information and i have created a calculated column to extract the time from the date. What i want to achieve is to create a time slicer e.g show me all occurrences which occurred between 6:00am and 10:00am for any date as long as that time was recorded next to it. Does anyone know if this is currently possible?

Cheers,


#2

What I would do here is exact the hour from the time as another calculated column

Then that would be easy to use as a slicer in your page. It would be just like any other numeric column and you would have off the functionality from the slicers available.

You can extract the hour really easily in the query editor. See below


#3

Thanks sam, i didnt think to go down and extract right to hours. Cheers.