Forum Discussion

gboiero's avatar
gboiero
New Member
2 years ago
Solved

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 interpret...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    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 Team

     

    If 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!

Anonymous's avatar
Anonymous
Not applicable
2 years ago

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 Team

 

If 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!

  • gboiero's avatar
    gboiero
    New Member
    2 years ago

    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])
    )