Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Create map for two attitudes and longitudes.

hello dears, what i'm trying to do is to creat map and spot one (latitude and longitude) with color black, and another one with different (latitude and longitude) in the same map with color red in o...
Need Help
Show and Tell
Tips and Tricks
  • v-yingjl's avatar
    v-yingjl
    6 years ago

    Hi Anonymous ,

    In power bi, table cannot be colored for themselves, we can only put the fields in the map and change the data colors in the data color menu as I previous posted.

     

    Best Regards,
    Yingjie Li

    If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

Pragati11's avatar
Pragati11
Icon for Super User rankSuper User
6 years ago

Hi Anonymous ,

 

I am not sure on why you have got 2 columns for LATITUDE and LONGITUDE in your data.

But, when I ty ry on a sample data as follows:

 

I get the following map:

 

I have got an ID column in my data - SCIID

I am using it under LEGEND field to give LATITUDE-LONGITUDE pair different colors.

 

See if you can try something like this.

 

Thanks,

Pragati

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    i have two (lat and long)

    one where the cabinet name is located and another (lat and long) for where the competitors is located, so i want to see both in one map

    • Pragati11's avatar
      Pragati11
      Icon for Super User rankSuper User
      6 years ago

      HI Anonymous ,

       

      It's not possible to plot 2 columns for LATUTUDE and LONGITUDE on a single map.

      You will have come up with a custom column that represents both these values in a single column.

      Like create a calculated column on some condition like - If COMPETITOR than LAT1 else LAT2

      Similarly, do it for LONGITUDE columns.

       

      You will end up with final 2 calculated columns - LAT_calc, LONG_calc.

       

      Now use these to plot on the map visual.

       

      Also, create a 3rd calculated column - CATEGORY = Competirors/Cabinet

      Use this CATEGORY column as a legend on your map.

       

      In this way you can compare them.

       

      Thanks,

      Pragati

      • Syndicate_Admin's avatar
        Syndicate_Admin
        Icon for Administrator rankAdministrator
        3 years ago

        the truth is that it is not a solution to the problem posed, I have the same problem and what I need is to turn the map into a kind of target, where an entity x has an assigned coordinate, and then all the locations where someone visits that entity. more specifically, I have coordinates of customers, which are fixed, and I have sellers who visit them and check in, what I need is to stare at that coordinate of the customer and day by day where the sellers were checking in to find the distance. and this problem as you will understand cannot be analyzed if I have everything in a single column. if or if I need to have two columns one of objective coordinate and one of real coordinates.

    • v-yingjl's avatar
      v-yingjl
      Icon for Community Support rankCommunity Support
      6 years ago

      Hi Anonymous ,

      Need another column to be used as legend field, for example:

      Put these columns in the map, change the data color and bubble size in the format menu as your need:

       

      Best Regards,
      Yingjie Li

      If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        can you explain more, i didn't understand what the value of legend showd be. i have two values of (lat and long) i put it in lat and long tab, and still one (lat and long) remaining  where i should put them?