Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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?
Solved! Go to 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.
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.
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.
Thank on my test model it worked my probem is I am importing from a cube and that function is greyed out
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.
User | Count |
---|---|
90 | |
74 | |
67 | |
63 | |
55 |
User | Count |
---|---|
101 | |
92 | |
74 | |
60 | |
59 |