Overlay Timezone in a Map in Power BI Desktop

[natyp]

Has anyone tried to overlay a timezone in the map visual in Power BI Desktop? The visual map is a global map with data of countries outside the US. The user ask is to overlay or apply a timezone in the visual map. Is this possible? Underlying data does not have a timestamp. Only Geograpy, Country and City. Thank you.

[v-pnaroju-msft]

Hi @natyp,

Thank you for the update. It is indeed commendable to note that you have created a global time zone table and successfully linked it with your main dataset, utilizing the timezone column as a legend on the map. This approach is both effective and scalable.

If your solution is functioning as expected, you may kindly mark the response that helped you the most as the Accepted Solution, so that other members of the community may benefit from it as well.

Should you have any further queries, please feel free to reach out to the Microsoft Fabric community.

Thank you.

[natyp]

@Akash_Varuna Thank you for responding.

I created a table of global timezones with cities and then created a relationship between this table and my main table and used that timezone column as legend on the map. 

[v-pnaroju-msft]

Hi natyp,

We wanted to check in regarding your query, as we have not heard back from you. If you have resolved the issue, sharing the solution with the community would be greatly appreciated and could help others encountering similar challenges.

If you found our response useful, kindly mark it as the accepted solution and provide kudos to guide other members.

Thank you.

[v-pnaroju-msft]

Thank you, @Akash_Varuna, for your response.

Hi @natyp,

We would like to check if the solution provided by @Akash_Varuna has resolved your issue. If you have found an alternative approach, we encourage you to share it with the community to assist others facing similar challenges.
If you found the response helpful, please mark it as the accepted solution and add kudos. This recognition benefits other members seeking solutions to similar queries.

Thank you.

[Akash_Varuna · Accepted solution]

Hi @natyp  The problem might be because Power BI map visuals can't automatically apply time zone data without a timestamp. You can manually add a time zone column based on country or city and display it on the map. Alternatively, use custom layers with tools like ArcGIS Maps for Power BI. Creating custom measures for time zone offsets can also help adjust data.