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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
dclifton
Regular Visitor

Problems with Filled Map not filling all States

I have been trying to work with a filled map and am unable to get it to properly fill all US states and Canadian provinces

 

I have a column that is the 2 letter state abbreviation. If I set this to data category state/province and map my locations, most of them are mapped, but some states are simply empty.

map by state code.JPG

If I change the data category of the state column to place, then the map is more complete, but gives me an error saying I don't have enough information. Some states are still missing completely, and some of the states that were previously filled are now empty.

map by state code as place.JPG

If I concatenate together 2 letter state code and 3 letter country code and set that new column as a place I get this map, still incomplete. Also still with the error of not enough information to map.map by state and country.JPG

If I switch to a normal map, everything looks correct when the state column is set to state/province data category. However this map is less visually appealling and I would prefer to be able to use the filled one if possible.

map by state code normal.JPG

Any tips on what the problem might be?

5 REPLIES 5
Anonymous
Not applicable

I have the same issue with Alabama and I can see data in the background, but it just won't show on a filled map. Is there anyone know how to solve this problem?

Hi Sienna:

  I posted a solution in a seperate thread:  

https://community.powerbi.com/t5/Desktop/Filled-Map-won-t-fill-a-US-state/m-p/244087/highlight/true#

 

Re: Filled Map won't fill a US state

 [ Edited ] 
 

I have a kludgy solution to this problem. It involves creating a new column in the table with the following formula:

 

US_States = IF('TableName'[AddressState]="LA","Louisiana,USA",'TableName'[AddressState]&",USA").

 

What this does is add a ",USA" suffix to each state abbreviation, and if the state="LA", spell out the state to "Louisiana, USA"- this is because Bing maps would otherwise plot LA as "Los Angeles" (good grief!).

 

You must set the new column of "US_States to a data category of "Place"

 

Hope someone else can benefit from this post

Anonymous
Not applicable

Thank you so much!

tmoey
Frequent Visitor

I am having  a similar issue as the original poster.

Would appreciate any pointers to correct this issue.

 

I am trying to create a filled map visual to show:

a) Count of Providers in the State (this count also controls the color saturation on the map)

b) Count of Networks in the State

 

The data is setup like this:

AddressState,   Network Count,  Provider Count

-----------------------------------------------------

UT                         3                          183

IL                         15                        1,235

 

 

The map fills correctly, except for the state of Utah, 

If I create a "Table" visual with the same data,

the counts for Utah show up correctly (so I know it is not a data or calculation issue).

 

I have set the "AddressState" field in Power BI Modeling to a Data Category of "State or Province"

 

 

Screen shot of the map with UTAH not filled in. 

MissingUtah.png

 

Screen shot of Table visual with the correct calculations for UT and IL:

CountsForMap.png

v-huizhn-msft
Employee
Employee

Hi @dclifton,

>>If I concatenate together 2 letter state code and 3 letter country code and set that new column as a place I get this map, still incomplete.

When you create the new column, don't set the Date Category, select it as location field. And check if it works fine. If it is still not resolved, do you mind share your sample data for further analysis. Besides, I post some article which is helpful to display data in map

Tips and Tricks for Power BI Map visualizations.
How-To: Display 2-letter country data on a Power BI map

Thanks,
Angelia



Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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