Forum Discussion
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 order to compare the locations, so how can i do it?
want these two maps locations in one map with two different colors
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.
19 Replies
- spg_vizcube
Helper II
You need to install custom Maps. Try Mapbox
- Pragati11
Super User
HI Anonymous ,
Not sure how your data is structured.
In your data set, you should have 2 columns - Latitude, Longitude
Then move these to your map visual and you can try with different color options to represent them.
It will be nice to have some sample data that you are using to achieve this.
Thanks,
Pragati
- Pragati11
Hi Anonymous ,
Again your comment is not enough to answer further.
add details so that we can try to resolve your issue.
Thanks,
Pragati
- Greg_Deckler
Community Champion
Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882
Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.Only thing I can say is to use a legend to get different colors on your map
- Pragati11
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
- Pragati11
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_AdminAdministrator
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 made an assigned visit to that entity x. more specific, I have coordinates of clients, which are fixed, and I have sellers who visit them day by day and must 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 between the check in point and the point where the customer really is. and this problem as you will understand can not 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.
