Forum Discussion
Create map for two attitudes and longitudes.
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 LiIf this post helps then please consider Accept it as the solution to help the other members find it more quickly.
Super UserHI 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
Administratorthe 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.