Zip code map on PBI

[laurafubj]

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. How can I do that？　

[Anonymous · Accepted solution]

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.

[Anonymous · Accepted solution]

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.

[jamesrcleveland]

Thank on my test model it worked my probem is I am importing from a cube and that function is greyed out

[laurafubj · Accepted solution]

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.