Custom Grouping of Zip Codes

[mcmum01]

Has anyone ever built a map with custom regions? I have a list of zip codes and the Metropolitan Statistical Area (MSA) that the zip code is a part of. I would like to create a heat map based on the MSA, not the zip code itself. Below is a screen shot of the map if I choose the zip codes in the Minneapolis/St. Paul MSA. What I would like is the full MSA highlighted, not the individual zip codes. This view eventually would be used to look at national level transactions and not on an MSA by MSA basis.

[rkozlowski]

I'm also trying to group zip codes, is there a solution for this?

[mcmum01]

I have not seen one yet.

[Stachu]

may have a workaround - consider this table

Mapping	State	Metric
A	IDAHO	5
A	UTAH	10
B	CALIFORNIA	15
B	NEVADA	20
C	OREGON	25
C	WASHINGTON	30

instead of using the Mapping column and

 Measure = SUM(Table[Metric])

we use the State column and the following measure

Measure = 
VAR CurrentMapping = SELECTEDVALUE('Table'[Mapping],BLANK())
RETURN
CALCULATE(SUM('Table'[Metric]),ALL('Table'[State]),'Table'[Mapping] = CurrentMapping)

which for each state gives the value of all states sharing the same mapping

[mcmum01]

Can you then map the measure based on the new grouping? So, Idaho and Utah would both be shaded some color and the weighting would be 15? California and Nevada would be another color weighted at 35, etc?

[Anonymous]

Also trying to create the same Region view. Has this been solved?

[skumaresh]

Hi,

We're trying to do exactly the same thing - did you ever get a solution for this requirement?

Thanks!

[v-yulgu-msft]

Hi @mcmum01,

I am not very clear about what you said "What I would like is the full MSA highlighted, not the individual zip codes. This view eventually would be used to look at national level transactions and not on an MSA by MSA basis.". Do you mean you want the entire MSA to be highlighted when you click one Zip code which is belong to MSA? If so, I'm afraid this is not achievable.

Regards,

Yuliana Gu

[mcmum01]

Below is some sample data and zip codes grouped by MSA. I could create a heat map and map the zip codes separately. What I would like to do is map the MSA by the zip codes in the MSA and have the heat based on the 2nd table. It would be no different than looking at sales by territory, or voters by district, as those are basically custom regions. I have zip codes that I would like to put into a "region" and my regions happened to be called MSAs.

[mcmum01]

I want to choose the MSA and have all the zip codes in the MSA make up the boundaries. A higher level example would be to create a sales terrirory called Pacific Northwest and have 2 states in it, WA and OR. When that territory is chosen those 2 states would be highlighted and other metrics associated with that territory would contribute to heat. Ultimately, I want a visual representation of transaction based on a custom region of zip codes, which in my case is MSAs.