Using a filter to only use times outside business hours

[Walt1010]

I'm trying to graph certain incoming calls that only fall outside business hours. I have a field that has type time (not datetime) that I wish to use. When I drag it into the filter pane and select Advanced Filter, it allows me to select hours with the range I want, but it appears to require a date for each test. Obviously I wish to use the filter for all dates and only use the time for the filter. How should I do this please?.

[Walt1010]

Thanks. Yes I thought about that too, as the only way around this.

[v-pgoloju]

Hi @Walt1010,

Thank you for reaching out to the Microsoft Fabric Forum Community.

And also thanks to @ToddChitt for Prompt and helpful solution.

Just following up to see if the solution provided was helpful in resolving your issue. Please feel free to let us know if you need any further assistance.

If the response addressed your query, kindly mark it as Accepted Solution and click Yes if you found it helpful  this will benefit others in the community as well.

Best regards,

Prasanna Kumar

[ToddChitt · Accepted solution]

I suggest you add a Calculated Column to the fact table that looks at the Time column. Try to see if you and structure it to return Yes/No or 1/0 based on a time comarison such as this:

[Is Outside Working Hours] = IF ( [Time] < "08:00:00" || [Time] > "17:00:00", "Yes", "No")

Note: the || is, I think, the logical OR operator for things like this.