Forum Discussion

GeorgeKwe's avatar
GeorgeKwe
New Member
3 years ago
Solved

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.
Need Help
  • v-jingzhang's avatar
    v-jingzhang
    3 years ago

    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!

v-jingzhang's avatar
v-jingzhang
Community Support
3 years ago

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!

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Did you eventually figure this out?