Forum Discussion

mcmum01's avatar
mcmum01
Icon for Helper I rankHelper I
8 years ago

Custom Grouping of Zip Codes

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.

 

Need Help

9 Replies

  • skumaresh's avatar
    skumaresh
    New Member
    8 years ago

    Hi,

     

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

     

    Thanks!

  • v-yulgu-msft's avatar
    v-yulgu-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    8 years ago

    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's avatar
      mcmum01
      Icon for Helper I rankHelper I
      8 years ago

      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's avatar
      mcmum01
      Icon for Helper I rankHelper I
      8 years ago

      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.

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

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

  • rkozlowski's avatar
    rkozlowski
    Frequent Visitor
    7 years ago

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

      • Stachu's avatar
        Stachu
        Icon for Community Champion rankCommunity Champion
        7 years ago

        may have a workaround - consider this table

        MappingStateMetric
        AIDAHO5
        AUTAH10
        BCALIFORNIA15
        BNEVADA20
        COREGON25
        CWASHINGTON30

        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