Difficulty displaying date/time data in 3 different timezones

[Omoyele]

Hi, Please is there a map like visual that allows me to view my data count on more than 3 time zones?. AlsoI have encoutered difficulties in converting from one timezone to another. It just errors out. Assuming my date/time data is in EST and I need to convert to AEST, GMT, what do I do?  Any advice is appreciated please. Thanks

[lbendlin · Accepted solution]

Always do all your calculations based on UTC and then at the very last moment let the UI switch over to the user's time zone.

Or, if you must, there are extensive time zone related functions in Power Query, including removing or modifying offsets.

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).

Do not include sensitive information or anything not related to the issue or question.

If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...

Please show the expected outcome based on the sample data you provided.

Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...