Forum Discussion

adidriksen's avatar
adidriksen
Regular Visitor
5 years ago
Solved

Using coordinates for a shape map

Can I use latitude and longitude coordinates to place observations on a shape map? I want Power BI to, for instance, be able to count the number of houses (in the data set) located in the Zentrum district of Cologne (there should be exactly one) and display this on the map.

 

Desired result 

Sample data 

  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi, adidriksen ,

     

    Thanks for your reply. I doubt if "shape map" visual has such a function. As far as I know, "shape map" does not have the function of setting longitude and latitude. 

     

    Best Regards,

    Yuna

7 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi adidriksen ,

     

    Sorry for that I cannot download the sample data from your posted link. Please save your files in OneDrive or any other cloud sharing platforms and share the link here. Thank you.

     

    Best Regards,

    Yuna

     

    • adidriksen's avatar
      adidriksen
      Regular Visitor

      Hello Yuna, thanks for bringing this to my attention. I had overlooked one of the privacy settings. The link should work now!

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi adidriksen ,

     

    Thanks for sharing your files.

    Based on your description, do you mean the "filled map" visual?  Where is "Zentrum" in your sample data?

    Is the following result what you want? Sorry I'm a little confused.

     

     

    Best Regards,

    Yuna

     

    • adidriksen's avatar
      adidriksen
      Regular Visitor

      Hi Yuna.

       

      I meant the shape map (it's a preview feature.) An example of how the shape map looks, and where Zentrum region is located, is here:

       

       

      I got that from using the .json as a custom map in the shape map visual. Now I want to count (for example) how many rows are located in the Zentrum region using the coordinates, like this (visual made with a different software):

       

       

      Bonus points if the sections of the map that do not have any observations could be cut away like in the example above!

      • Anonymous's avatar
        Anonymous
        Not applicable

        Hi, adidriksen ,

         

        Thanks for your reply. I doubt if "shape map" visual has such a function. As far as I know, "shape map" does not have the function of setting longitude and latitude. 

         

        Best Regards,

        Yuna

  • ELW's avatar
    ELW
    Advocate II

    It's been almost three years, is there still no solution to a map visual with both shapes and points?