Forum Discussion
Drill down showing wrong state.
Hi, Cortana
Thank you for the problem description, according to your problem, in fact, this is also a common problem in using Map visuals in Power BI, because if you do not give and visually put the longitude, latitude, and hierarchy of the corresponding region (from which country, which state) in the dataset, the Map visual used in Power BI will be ambiguous in identifying information, even if it is displayed on desktop. There will also be a certain amount and degree of ambiguity when displaying the service in the cloud.
Sometimes, even setting a data category for a map isn't enough for Bing to correctly guess your intent. Some names are ambiguous because the location exists in multiple countries or regions. For example, England, Pennsylvania, and New York have a Southampton.
Power BI uses Bing's unstructured URL template service to get latitude and longitude coordinates based on a set of address values for any country. If your data doesn't contain enough location data, add these columns and categorize them appropriately.
This suggestion is also included in Power BI's official documentation on tips for improving the underlying dataset of Map visua, which you can refer to to to improve your dataset to provide a better Map visua experience and effect for end users:
Tips and Tricks for maps (including Bing Maps integration) - Power BI | Microsoft Learn
Thank you for your time and sharing, and thank you for your support and understanding of PowerBI!
Best Regards,
Aniya Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Thank you so much for your reply v-yueyunzh-msft
Actually, I was using a custom visual Drilldown Choropleth map. My problem was only for California state. My data contains the States code County names and statistics. I know for maps it gets complicated sometimes. These things worked fine before but now it's not. So is there any reason for that or any solution that I can follow?