Forum Discussion
Problem Filter Today shows me data from tomorrow without respecting my time zone
Hello!
I have a dashboard with a page that filters today's data. However, in Power BI Desktop and Web after 9pm (I am in geographic zone -3) it stops showing today's data, since the filter interprets that it is tomorrow.
I have the correct geozone on my PC, in Power BI Desktop and Service, but I can't get it to work correctly. Is it a PowerBI bug? Can you help me?
Thanks.
Hi gboiero ,
The condition can happen because Power BI service operates on UTC time, which can cause discrepancies when you’re in a different time zone. If you use DAX functions like TODAY() or NOW(). These functions return the server’s date and time, which may not match your local time zone.
You can refer to these links, these methods explained help ensure that the date and time displayed in Power BI reports are accurate for your specific time zone.:
Solving DAX Time Zone Issue in Power BI - RADACAD& Power BI Service Time Differences and How to Fix It (linkedin.com)
Best Regards,
Zhu
Community Support TeamIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
2 Replies
Hi gboiero ,
The condition can happen because Power BI service operates on UTC time, which can cause discrepancies when you’re in a different time zone. If you use DAX functions like TODAY() or NOW(). These functions return the server’s date and time, which may not match your local time zone.
You can refer to these links, these methods explained help ensure that the date and time displayed in Power BI reports are accurate for your specific time zone.:
Solving DAX Time Zone Issue in Power BI - RADACAD& Power BI Service Time Differences and How to Fix It (linkedin.com)
Best Regards,
Zhu
Community Support TeamIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!Hi!
Thanks! I resolved it to add new column in the calendar table with DAX formule. When UTC Hour is between 0 and 3AM, I add one day to original date, so compared this column date with filter today. For example:
FechaTMZ0 =var HoraPBIServer = UTCNOW()return IF(AND(HOUR(HoraPBIServer)>= 0, HOUR(HoraPBIServer)<=3),calendario[Fecha]+1,(calendario[Fecha]))
