cancel
Showing results for 
Search instead for 
Did you mean: 
Reply

Plotting with ZIP3 boundary

Dear PowerBI Community,

 

My data set requires me to plot by the first 3 digit of the US Zipcode.

Is there a way to plot it by the Zip3 boundary?

 

Thanks

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
v-ljerr-msft Super Contributor
Super Contributor

Re: Plotting with ZIP3 boundary

Hi @FrugalEconomist,

 

If I understand you correctly, you should be able to use the formula below to add a new calculate column into your table to get the first 3 digit of the US Zipcode, then plot with the new created calculated column on the report.

 

First3Zip = LEFT ( Geo[Zip], 3 )

In addition, here is a similar thread for your reference.Smiley Happy 

 

Regards

1 REPLY 1
Highlighted
v-ljerr-msft Super Contributor
Super Contributor

Re: Plotting with ZIP3 boundary

Hi @FrugalEconomist,

 

If I understand you correctly, you should be able to use the formula below to add a new calculate column into your table to get the first 3 digit of the US Zipcode, then plot with the new created calculated column on the report.

 

First3Zip = LEFT ( Geo[Zip], 3 )

In addition, here is a similar thread for your reference.Smiley Happy 

 

Regards