How can I get a slicer with HH:MM

[vpertuz]

I'm using a Time Slicer like the red square in the following picture to filter time between a time set of information like the one in the green square; the problem we are facing is when we set the slicer from 8 to 12 we are expecting to get only the information (8:10, 9:01, 11:12) but we are also getting data from 12:05 since the slicer don't allow us to set minutes.

The question I have is how to get HH and MM in the slicer?
Or how can i filter only data until 12:00

[v-yuezhe-msft]

@vpertuz,

When you drag Time type field to a slicer, you can choose List format in the slicer, which will show you a list of HH:MM values.



Regards,
Lydia

[vpertuz]

@v-yuezhe-msft

Thanks for your answer, howver this is not possible in our case since we manage a lot of records of datetime and this is not efficient.

is there a way to search for data bewteen date/time:

Example:

from: 04/18/2018 - 08:00 to:  04/18/2018 - 13:00 

kind regards

[v-yuezhe-msft]

@vpertuz,

The built-in slicer doesn't provide date/time format as you describe, there is an idea about this issue, please vote it up.

In addition, you can check if Advanced Time slicer custom visual meets your requirement. Here is a blog for your reference.

Regards,
Lydia