Forum Discussion
Filled Map Bug?
I'm trying to use the filled map visualization in Power BI, but it is being unpredicatable and showing incorrect information. Is this a bug, or could I be doing something wrong?
E.g. In this map, I used "animal_state" to color the animal state in the map and I have the data category appropriately listed. IA should be blue and GA shouldn't be included at all. But, Power BI is coloring GA instead of IA.
I tried it differently and created a new field with State, USA and used that to map. In this map, I used "State, USA" to color the animal state in the map and I have the data category appropriately listed. CO should be blue and GA shouldn't be included at all. But, Power BI is coloring GA instead of CO.
Instead of using the filled map for state, I decided to try county. In Power BI desktop, I have a filled map by county, here is teh column tools ribbon:
Here is a portion of the filled map:
It appeared to be working on Power BI desktop, so I published to an online workspace and updated my App, and this is how the exact same map displays online:
Does the filled map in Power BI just not work? Or am I missing something? I've check the data, it is all accurate. Thanks!
Hi TBStacey - To get the shape map, click on File in the top-left corner, then select Options and settings, and then click on Options.In the Options window, go to the Preview features section. Check the box for Shape map visual. Click OK to confirm. You will need to restart Power BI Desktop for the change to take effect.
Configure the data category
Select the locaton/state provience columns,In the Column tools tab, set the Data category to "State or Province".
Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!
6 Replies
Hi TBStacey -The filled map visualization in Power BI can sometimes be unpredictable due to a variety of reasons, such as geocoding issues, ambiguous location names, or mismatched data categories
Can you create a calculated column by concatenating by adding the geographic data, especially for states and counties, it’s often helpful to use full names (e.g., "Colorado, USA" or "Jefferson County, Colorado, USA") to avoid ambiguity.
Using DAX calculated column:
Eg: Full_State_Name = 'Table'[State] & ", USA"
Full_County_Name = 'Table'[County] & ", " & 'Table'[State] & ", USA"you can try even the shape map highlighted for only dedicatedly working on a particular country and their state analysis highlighted in build a visual with green color is shape map.
Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!I tried full names too, and it didn't work either. As you see below, I tried "Colorado, USA" and the map filled in Goeorgia.
Hi TBStacey - if you can provide some sample data , will check.
I have just tried with same configuration of state & country concatenation, filled map is working fine as expected. can you also check the Shape map ?
Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!
