Forum Discussion
Mismatch between Local Time and Filter Date
Hi Anonymous
I did a simple test and it looks like the date/time filter in Power BI Desktop is based on the current UTC time and not the time zone set by the system.
In the test, I changed the system time zone to UTC + 12:00, as shown in the image, the system time and NOW() function returns the time UTC + 12:00 and the UTCNOW() function returns the current UTC time, when I set up the relative time filter in the visual filter pane, we can see that it is filtering based on the time of UTCNOW().Best Regards,
Jarvis Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
This is in Desktop which is why I'm confused
Hi Anonymous
I did a simple test and it looks like the date/time filter in Power BI Desktop is based on the current UTC time and not the time zone set by the system.
In the test, I changed the system time zone to UTC + 12:00, as shown in the image, the system time and NOW() function returns the time UTC + 12:00 and the UTCNOW() function returns the current UTC time, when I set up the relative time filter in the visual filter pane, we can see that it is filtering based on the time of UTCNOW().
Best Regards,
Jarvis Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thanks for looking into it so it seems that this is intended behavior... which I think would be understandable for Power BI Service but makes no sense for Power BI Desktop