Forum Discussion
Power BI Map - Sales Data
Community ChampionHi Anonymous
Yes, that would work well. You could then switch from Map visual to Shape / Filled visual and limit it to the US states at a shape level. Add a few little options within the visual menu, and it would look great!
Cheers mate! Well done.
Theo
TheoC In theory it works however how will i establish one to many relation. 1 census division may have 6 or 7 states listed under it and i dont have state level sales data. Sales data is at census region level.
I also have DMA data i wonder if there is way to plot based on that rather than US census or divsion data.
Thanks
- TheoC
Anonymous
Grab the JSON files for the US census regions, add them to your shape, and you've got exactly what you need:
For US maps: https://github.com/d3/d3/wiki/gallery/#maps
(original source: https://community.powerbi.com/t5/Desktop/US-states-Shape-Map-JSON-file/m-p/79071)
This should resolve the problem 🙂
TheoC Thank you for sharing the github link however when i try to download file link broken link and doesnt work. Do you know of any other source that has the files
- TheoC
Anonymous try this one:
https://github.com/johan/world.geo.json/tree/master/countries/USA