Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now

Reply
Cortana
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?

 

2 REPLIES 2
v-yueyunzh-msft
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

Announcements
November Carousel

Fabric Community Update - November 2024

Find out what's new and trending in the Fabric Community.

Live Sessions with Fabric DB

Be one of the first to start using Fabric Databases

Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.

Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

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