Forum Discussion
Date & Time slicer
- Anonymous3 years ago
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.
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.