Forum Discussion

Ondrix's avatar
Ondrix
Regular Visitor
2 years ago

Power BI geocoding - Display results on map based on mixed datainput

Hello,

 

i m using map connector at power bi where i have hierarchy of Country - ZIP - CITY - Street.

It works pretty nice but in my table there are sometimes missing these these data in some rows, but i have another columns there Longtitude and Latitude that are not 100% present at every row eighter. 

So i would like to use these together on condition if street data are not present find bubble on map based on Longtitude and Latitude instead of that hierarchy.

But i have recieved this error.


This is my Visualization set up 

 


Do you have any clues how to solve my problem? 

Thanks in advance.

Tips and Tricks

2 Replies

  • Brunner_BI's avatar
    Brunner_BI
    Icon for Impactful Individual rankImpactful Individual
    2 years ago

    Maybe you can try to build a conditional column that gives you the locations when the "location" is empty in Power Query.


    Then try to use this new column in the location tab, I dont know if coordinates work in there but they could.

    • Ondrix's avatar
      Ondrix
      Regular Visitor
      2 years ago

      I have putted coordinates to location field but it show incorrect bubbles on map based only on first coordinate you give there so in my case its based only on latitude