Slicer to filter by both date and time

[Arranafc19]

Hi

I am looking to add a slicer go a report which will factor in both Date and Time of a time stamp.

I need to be able to filter from Today at 6pm to tomorrow at 6pm . 

Is there a way to add this to the slicer ? I only seem to be able to get the date range without time 

[v-yingjl]

Hi @Arranafc19 ,

If you've fixed the issue on your own please kindly share your solution. If the above posts help, please kindly mark it as a solution to help others find it more quickly. Thanks!

Best Regards,
Yingjie Li

[v-yingjl]

Hi @Arranafc19 ,

Enable the 'Related time filter' in preview features menu, restart power bi desktop and you can choose time slicer in it.

Best Regards,
Yingjie Li

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

[Arranafc19]

Hi @v-yingjl  @amitchandak 

Thanks for replying , however this is not exactly what I am looking for.

In my dataset I have a date field which records a date with a timestamp too eg : 2020-06-08 21:36:00.

What I need is to be able to pick a start date and time and an end date and time to filter the report by :

E.g 

Start 02/03/2020 18:00:00   End 09/03/2020 17:59:00 

The report would then pull all dates between these two periods of time 

[v-yingjl]

Hi @Arranafc19 ,

Try to use advanced filtering and add date conditions in it:

Best Regards,
Yingjie Li

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Arranafc19 , you may have to check for a custom one.

In April 2020  release you have a relative time slicer

https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-april-2020-feature-summary/#_Relative_time...