Forum Discussion
Solved
Auto Refresh on Power BI Service changes my chart values
Hey Community, I have an issue with 2 charts in my dahsboard which is from MySQL database, these 2 charts has the below formula. I have the following formulas to calculate the response time ...
Hi Anonymous, The issue is now resolved. I tried the method again from the YouTube video, by following everything on this video except for one of the steps where I found out in the comments section that I needed to replace the step "DateTimeZone.ToLocal" to "DateTimeZone.SwitchZone-([UTC-ColumnName_UTC],0).. To always display the information in the time zone it was collected. Thanks!
You should not. Instead, make sure all your datetime values are in UTC as well, and leave it up to the users' browsers to convert to the local timezone.
I will work this out. Thank you for the response.