Forum Discussion
Time Slicer
I am looking how to use a slicer to filter between different times of the days. For instance, Say i wanna filter between 10am and 3pm using a slicer instead of the relative date filter.
Hi GeorgeKwe
I'm afraid currently there is no such time slicer that can meet your need. As a workaround, you can get the behaviour by creating a new column.
HourForSlicer = HOUR([date_field])
You can then create a slicer based on the date and another slicer based on the hour.
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it. Highly appreciate your Kudos!
2 Replies
- v-jingzhangCommunity Support
Hi GeorgeKwe
I'm afraid currently there is no such time slicer that can meet your need. As a workaround, you can get the behaviour by creating a new column.
HourForSlicer = HOUR([date_field])
You can then create a slicer based on the date and another slicer based on the hour.
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it. Highly appreciate your Kudos!- AnonymousNot applicable
Did you eventually figure this out?