Mapping 3-digit US postal codes

[KimC16]

Hello -

I am trying to map 3-digit postal codes (i.e., just the first three digits of the postal code) in the US. 

I have created a column which pulls the left three digits - I have confirmed that this column is in text, categorized as a postal code and that the zero in the front does not get dropped.

However, the map displayed does not chart any that start with a zero (see below highlighted in yellow). Has anyone run into this problem before and can help advise? 

[OwenAuger · Accepted solution]

Hi @KimC16 

Try constructing a column containing the 3-digit code followed by ", USA", (the Postal Code - Country column below), and set Data Category to Place.

This seems to work for me (PBIX attached). Does it work for you?