Filled Map Bug?

[TBStacey]

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!

[rajendraongole1]

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!!

[TBStacey]

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. 

[rajendraongole1]

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!!

[TBStacey]

I don't have the 'Shape Map' in my options. I looked to see if I could import it, but it wasn't an option in the addtional list either.

The problem with providing sample data is, the Filled Map is not consistent on when it works and when it doesn't, as you can see via my previous photos. Sometimes it displays correctly on the desktop version, but the same version will not work on the online app when published there. Sometimes it won't display correctly on the desktop version or online app. It doesn't seem to be predictable, but the data source is always the same.

I can't change the source data as it is connected to a database, I can only change the field the map populates from (such as using the animal_state which says 'CO' and creating a new field that says 'Colorado, USA' which is displaying in the filled map as GA (per photo above). 

Georgia is not an animal_state in any rows within the dataset, so I don't understand why it keeps getting filled depending on what I'm trying to pull in. County or State, Georgia keeps getting filled. I even checked on the county that is populating when Georgia is filled and a county with that name (Comanche County, Texas) doesn't exist in the state of Georgia.

[rajendraongole1 · Accepted solution]

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!!

[TBStacey]

The shape map is accurately reflecting the data. While that doesn't solve the problem of the filled map not working accurately, it does provide a work around, so thank you! I'll mark your reply as the solution (work around)). Maybe someday the filled map will work accurately, until then, I appreciate having an accurate option.