Relative date in a Gauge does not display properly

[Cyrilbrd]

Good day,

I have a query that gets info from our server located in the same city.

The visualizations worked perfectly until this morning.
-One gauge is set as relative date "is in this" "day"

-One gauge is set as relative date "is in the last" & "1" & "days" with the option "Include today" left unchecked.

-One Card shows the latest RefreshTime (= DateTime.LocalNow())

Upon refreshing the queries from 192.168ect the visualization for the timestamp (lastest RefreshTime) shows the date and time properly as today, yet both gauges are showing yesterday for today and the day before yesterday for yesterday, so 24 hours difference.

Example:

Time Refresh show 27th of July 2020 7:50

Gauge one shows July 26th intead of July 27th sales data

Gauge two shows July 25th instead of July 26th sales data

This is weird as it just happened this morning.

Any clue?

[amitchandak]

@Cyrilbrd , this might be timezone setting issue. Your desktop might have different timezone then data server?

refer for TimeZone
https://www.poweredsolutions.co/2019/10/21/handling-different-time-zones-in-power-bi-power-query/
https://community.powerbi.com/t5/Desktop/Convert-UTC-to-client-time-zones/td-p/56337
https://www.youtube.com/watch?v=M1zquwmpnZE

[Cyrilbrd]

Thank you for your reply, no the server and the desktop are both set on the same timezone, as I mentioned this happened just today, I never had any issue with the visualizations prior to today.

I re-created the dashboard from scratch and deleted the previous faulty one.

I fear I will never really know wht happened nor what triggered this sudden change in the date called in the query.

Alas, thank you for your input.