Universal setting to display all time in local time zone (BST/U.K. time)

[po]

Hi,

We currently get supplied date/times in UTC format from a system and have to convert these to BST in the database so times display in required U.K. format.

I believe power bi service still displays times in UTC format.

Is there a simple one setting way for power bi service to disaplay all UTC times in BST/U.K, time without having to convert each and every time to BST either at database level or in power bi itself with separate measure

Thanks

[v-zhangti]

Hi, @po 

You can try to change the date format by setting the region in Power BI Desktop-File-Options and settings-Options-Regional Settings.

You can also refer to the following links, which I hope will help you.

https://community.powerbi.com/t5/Service/Incorrect-Time-Zone-setting-at-Power-BI-Service/m-p/2345344 

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

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[po]

Hi,

Thanks for reply and links.