This is best Fabric, Power BI, SQL and AI community event. How do we know? The last event sold out! Save €200 with code FABCMTY200.
Register nowThe Fabric community is upgrading! Read all of the details including the timeline and what you can expect. Learn more
I am looking to visualize my data using a map visual in Power BI and my options are as follows and a note about the experience.
Dataset, Zip code data for USA & Canada
Filled Map (Bing Maps) - Great tool, looks good, visually what I want however performance is terrible!
ArcGIS Map (Esri Maps) - Reasonable alternative however not quite the same experience, Bubbles don't work as well as the "area", and conditional formating is not possible?
Shape Map - Would be VERY interested in this becuase the data is contained in the model however who would know where i can get a zip code version for USA & Canada?
Thanks!
Hi @orangeatom
Here are some articles about shape map for your reference.
http://radacad.com/shape-map-better-than-the-filled-map
https://community.powerbi.com/t5/Desktop/Zip-code-map-on-PBI/td-p/516801
Regards,
Cherie
Thank you to both, the Cartographic dataset is good however following the tutorial on producing a TopoJson out of it doesn't work. An errors is created (Perhaps file is too large?)
Are there any options to optimize the Bing map or any additional options on sourcing a Zipcode shape map?
What was the solution, if any, to implementing a shape map by US zip code?
Is this useful?
"The cartographic boundary files are simplified representations of selected geographic areas from the Census Bureau’s MAF/TIGER geographic database. These boundary files are specifically designed for small scale thematic mapping.
Generalized boundary files are clipped to a simplified version of the U.S. outline. As a result, some off-shore areas may be excluded from the generalized files."
https://www.census.gov/geo/maps-data/data/cbf/cbf_zcta.html
Join us in Barcelona for FabCon and SQLCon, the Fabric, Power BI, SQL, and AI community event. Save €200 with code FABCMTY200.
| User | Count |
|---|---|
| 24 | |
| 22 | |
| 20 | |
| 18 | |
| 14 |
| User | Count |
|---|---|
| 29 | |
| 23 | |
| 22 | |
| 20 | |
| 20 |