Power BI Map - Sales Data

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 🙂

Anonymous check this link out: https://docs.microsoft.com/en-us/power-bi/visuals/desktop-shape-map

Anonymous it should be one of the following: https://www.census.gov/geographies/mapping-files/time-series/geo/carto-boundary-file.html

Try one of the Nation or Region zips.

Cheers

Theo

Anonymous you may need to convert to JSON: https://www.statsilk.com/maps/convert-esri-shapefile-map-geojso

TheoC  I am using a measure not pulling it from field pane. I went back to the original plan, brought in US States Geo Json file into power bi. Created a table with Census Division and States and linked it to the source data.  I have below formula to calculate the average sum for each census divison. It worked for me ut hd to get creative. I couldnt have done without help of TheoC. Thank you! 

POS Sales = var _currentCensus = MAX(Region[Census Division])
var _sum = SUM(Region[Values])
var _uniquestates = CALCULATE(DISTINCTCOUNT(Map[State]),
    Region[Census Division]=_currentCensus)

var _calculation = DIVIDE(_sum,_uniquestates)
return _calculation