Forum Discussion

dokat's avatar
dokat
Post Prodigy
4 years ago
Solved

Power BI Map - Sales Data

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 ...
Need Help
  • dokat's avatar
    dokat
    Post Prodigy
    4 years ago

    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

     

     

     

     

  • dokat's avatar
    dokat
    Post Prodigy
    4 years ago

    TheoC Thank you i converted the files to GEOJson format and import it to power BI. However when i put it in location it dollars (values) under color saturation it change the map. I put . What may cause this issue? Below is the screenshot

     

     

  • dokat's avatar
    dokat
    Post Prodigy
    4 years ago

    TheoC I got map to work. I had to convert the data to TopoJson format before importing and use custom map option. My challange right now is state of alaska shows in the map which i'd like to exclude.

     

     

  • TheoC's avatar
    TheoC
    Community Champion
    4 years ago

    Hi dokat 

     

    A few things can cause this but is likely stemming from a change to excluding Alaska?  The other factor could be the values and their format?  Are you using a measure for the values (i.e. SUM ( Table[Amount] ) or pulling straight from the field pane?  

     

    Cheers mate.

    Theo 

     

  • TheoC's avatar
    TheoC
    Community Champion
    4 years ago

    dokat the map looks sensational mate!  Well done on getting there.  In all honesty, I think you could put together your first blog post on the Community about how you went through this process; a step-by-step guide on this.  Many members of the Community would find it beneficial!!