Slicing a time interval within a day

[bookhouseboy]

Hi,

as the title says, I'm stuck on slicing a time interval within a day. 

So, I have minute-by-minute data. My time-of-day variable is of the data type "time", I made sure of that in PowerQuery. Yet when I put it in a slicer with "Between" as the slicing type, all I get is this:

So is there no way to filter, say, 9 am to 11 am? Or am I just too stupid to find it?

[SamWiseOwl · Accepted solution]

Hi @bookhouseboy 

Sadly it isn't an automatic option. 

You have a couple of choices:
Use the Relative Time slicer option:

Create a date and time slicer seperate:
Solved: Range slicer by time of day AND NOT by date. - Microsoft Fabric Community

Or do some fancy stuff with numbers:

Solved: Slider Slicer that Includes Time (Not just Date) - Microsoft Fabric Community

[bookhouseboy]

Thank you. That's a bit discouraging -- but thank you for the compilation of options!