Forum Discussion
Filled Map Bug?
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!!
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!!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.
