Forum Discussion

laurafubj's avatar
laurafubj
Regular Visitor
7 years ago
Solved

Zip code map on PBI

Hi, I want to have a report based on 5 digit zip code, with the map that shows different zip code areas, I will use the count of sales on that map to show the different color on the zip code area. Ho...
  • Anonymous's avatar
    Anonymous
    7 years ago

    First thing you are going to have to do make use of the "Data Category" in the Modelling tab of the ribbon.  Next you'll need to configure your Map visual to make use of the Zip code in the "Location" section of the visual and the Sales column will need to be in the Size/Color sections of your visual.

     

    It might not work immedately as Zip codes are likely not enough of an identifier for a map.  Its likely you will need to add more location data into your locations tables, possibly with Lat/Long coordinates to get something accurate.

     

    Alternateively you could use the Synoptic Panel by OKViz (custom visual) and fill in a map drawing that has your Zip boundries/shapes set up.  This can be a better option if you want more control.

  • laurafubj's avatar
    laurafubj
    7 years ago

    Thank you! I am using ArcGIS to populate my data, and it works, but you are right, if I need specific boundary zip map, I have to use Synoptic Panel by OKViz, I still need to study on this.