Forum Discussion

send2prasan's avatar
send2prasan
Helper I
9 years ago
Solved

Mapping and limitations

Dear all,   I have couple of questions related Mapping capability in power bi. My data hierarchy is something like this   Level 1: Area ==> Filled map to represent the bountry of various areas L...
Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

    send2prasan

     

    I'm not sure whether it is possible or not, but it kind of goes against the idea of filled map. It's not suppose to be destinations, it's suppose to be larger areas. So plotting an entire address doesn't really make sense.

Anonymous's avatar
Anonymous
Not applicable
9 years ago

send2prasan

 

This approach has worked for me before:

 

Column = Postalcode&" "&Country

 

or

 

Column = Postalcode&" "&Countrycode

 

Try this and get back to me.

send2prasan's avatar
send2prasan
Helper I
9 years ago

Martin,

 

This is not working for me. can you please try with these pin codes of SRI LANKA:

 

AgaliyaSri Lanka 80212
AhangamaSri Lanka 80650
AhungallaSri Lanka 80562
AkmeemanaSri Lanka 80090
AluthwalaSri Lanka 80332

 

Thanks,

Prasanna V.

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    send2prasan,

    Could you please share the full sample data of your table that can be copied?  Besides, do you mean that 4th entity(Zip code2) doesn’t related to correct place?

    Regards,
    Lydia

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    It looks like the filled map visualization can't take postal codes from sri lanka. It can however take the cities. Try this combination:

     

    Table[City]&" "&Table[Country].

    • send2prasan's avatar
      send2prasan
      Helper I
      9 years ago

      Dear all,

       

      Please use this data file for mapping (WeTransfer link):

       

      https://we.tl/IVOkIyNyYa

       

       

      One more question: is there any way I can mark complete addres on filled map:

       

      For example: No. 06 Heen Ela Road, 06, Hien Ela Road, Ambalangoda, Southern 80300, SRI LANKA

       

      Thanks,

      Prasanna V.

      • Anonymous's avatar
        Anonymous
        Not applicable
        9 years ago

        send2prasan

         

        I'm not sure whether it is possible or not, but it kind of goes against the idea of filled map. It's not suppose to be destinations, it's suppose to be larger areas. So plotting an entire address doesn't really make sense.