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!
SowmiSakthi21 Can you check whether you have any page level or visual level filters applied ? Also try turning off auto time intelligence feature, publish and refresh the model.
Thanks,
Jai
Yes we do have a page level filter for each page. How does that interfere with this? So we have one page that filters for the month and another page for the week.
