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?
Helpful resources
Power BI Monthly Update - April 2026
Check out the April 2026 Power BI update to learn about new features.
Data Days 2026 coming soon!
Sign up to receive a private message when registration opens and key events begin.
New to Fabric Survey
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
Power BI DataViz World Championships - June 2026
A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.
