Hi, I am trying to map out my sales data with power bi. Below is the format of my census division data. I dont have longtidue or lattiudue . Based on below census divisions is it possible to map out my data in power bi? Census DivisionMeasuresValuesNew EnglandDollars$13,024Middle AtlanticDollars$11,044East North CentralDollars$22,402West North CentralDollars$13,233South AtlanticDollars$17,095East South CentralDollars$13,997West South CentralDollars$14,064MountainDollars$10,279PacificDollars$7,849South AtlanticDollars$710East South CentralDollars$391New EnglandDollars$1,899Middle AtlanticDollars$4,363East North CentralDollars$8,963West North CentralDollars$3,282South AtlanticDollars$5,818East South CentralDollars$1,677West South CentralDollars$2,318

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

Power BI Map - Sales Data | Microsoft Fabric Community

Forum Discussion

19 Replies

Related content