Date & Time slicer

[Akshay123]

Hello Everyone

I have date & time column, I need to create slicer that where user can select between dates & timings.

For ex I need to see data what happen between 10th April 2023 11:00 AM IST to 13th April 2023 1:00 PM IST.

[v-stephen-msft · Accepted solution]

Hi @Akshay123 ,

Yes, you can create a slicer or set up a filter in the Filters to filter the date/time.

Slicers in Power BI - Power BI | Microsoft Learn

Add a filter to a report in Power BI - Power BI | Microsoft Learn

Create a relative date slicer or filter in Power BI - Power BI | Microsoft Learn

Create a relative time slicer or filter in Power BI - Power BI | Microsoft Learn

However, it only works for UTC time and not for local time. The slicer and filter are always based on the time in UTC. If you set up a filter in a report and send it to a colleague in a different time zone, you both see the same data. Unless you or your colleague are in the same UTC time zone, you both must account for the time offset you’ll experience. Use the Query Editor to convert data captured in a local time zone to UTC.

Create a relative time slicer or filter in Power BI - Power BI | Microsoft Learn

Best Regards,

Stephen Tao

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