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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
preston-t
New Member

Filled Maps for U.S. States and Territories

prestont_0-1736871332348.png

 

In the image above on PowerBI Desktop, I can't seem to get certain teritories to fill in without the compromise of affecting other states switching to cities to fill in the map e.g. New York -> New York City [New York, New York]

 

All other forums online may address one issue, but seemingly have not yeilded the desired operation. 

 

I would greatly appreciate guidance on this and some background as to how this issue has been around for nearly 10 years.

 

Thank you!

 

2 REPLIES 2
hackcrr
Super User
Super User

hi @preston-t 

Ensure that your geographic fields (like state and city) are formatted correctly. In PowerBI, they should be set to ‘Geography’ with the appropriate sub-type (e.g., ‘City’ or ‘State/Province’).

Sometimes you might need to merge fields to create a full address or geographic identifier that PowerBI can recognize. For example, you might need to concatenate ‘City’, ‘State’, and ‘Country’ into one field.

Hi @hackcrr! Thanks for your response. I am currently only using State / Territory. I had already attempted to add ', United Sates' at the end of every State or Territory and this did not resolve the issue with territories. For setting the geography I have selected the data category of "State or Province" from the table view for said column. In PQE I do not see an option for anything other than the standard data types for selecting.

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

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