Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Helper III
Helper III

Drill down showing wrong state.

So I was using the drill-down choropleth map for US states and counties. Here is my graph-

image (3).png

Here, I used a button (bottom right). The button is disabled primarily. It will be enabled when I select a state from the graph as below- image (4).png

 Here I selected Nevada state. Then I clicked the button to drill down through the counties under this state like below- image (5).png

Now the problem is this thing is working well except the California state. All the states I select, take me to their own counties except California. When I select California it takes me to Alaska. See the picture below- image (6).png Here I selected California state. Now when I drill down, It takes me to Alaska- image (7).png 

The weird thing is a couple of months ago I made a report like this one and It still works fine. But now whenever I try to make the same report again it is showing me the same issue. Only California state is behaving weirdly.  Is it a bug? or Am I missing something?


Community Support
Community Support

 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?

Helpful resources

PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors