How to change the dates UTC to Local

[Mallika_n]

Hi,

I have created report in Power Desktop and Published to the service it is working fine in Desktop,

but i have an issue with dates after publishing to service. Every visual is working fine except the rolling average visual, where as it working fine after 12Pm NZST.

please help me to get the correct date .

[v-angzheng-msft]

Hi, @Mallika_n 

Not sure which method is right for your case so I've posted as many references as possible below. I hope some of these methods are useful to you.

Here are some references that may be helpful:

community:

display date/times in local timezone rather than UTC

Desktop refreshes correctly show the converted local time dates but the Service reverts back to UTC?

Changing time From UTC to Local Time

UTC to Local as measure

UTC timezone issue

Relative Time Slicer UTC

Convert UTC to local time zone in DAX

blogs:

https://www.excelguru.ca/blog/2016/06/08/display-last-refreshed-date-in-power-bi/

https://cloudbi.com.au/converting-utc-to-local-datetime-in-power-bi/

https://nolock.medium.com/how-to-convert-utc-to-your-local-time-zone-in-power-query-c10538fa849a

https://www.thepoweruser.com/2019/10/21/handling-different-time-zones-in-power-bi-power-query/

https://whitepages.unlimitedviz.com/2020/10/dynamic-time-zone-conversion-using-power-bi/

https://intellitect.com/convert-utc-local-time-daylight-savings-support-power-bi/

https://forum.enterprisedna.co/t/converting-utc-to-local-time-zone-in-power-bi/11346

Hope this helps.

Best Regards,
Community Support Team _ Zeon Zheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Mallika_n]

Nothing worked for me ☹️, I am getting data now but in desktop it is showing todays date and in service it is showing blank instead of  date untill 12pm nzst 

[Mallika_n]

Thanks for the Response I tried 1 and 2 methods but Didn't work for me.

[lbendlin]

You may want to consider this article Solving DAX Time Zone Issue in Power BI - RADACAD