Forum Discussion

KimC16's avatar
KimC16
New Member
1 year ago
Solved

Mapping 3-digit US postal codes

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? 

 

 

 

  • 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?

     

1 Reply

  • 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?