Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
So I was using the drill-down choropleth map for US states and counties. Here is my graph-
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-
Here I selected Nevada state. Then I clicked the button to drill down through the counties under this state like below-
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- Here I selected California state. Now when I drill down, It takes me to Alaska-
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?
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?
Check out the September 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.