cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
datadude28 Frequent Visitor
Frequent Visitor

How to color code different GPS coordinates by category?

 

Hi everyone,

 

I am having trouble color coding two GPS coordinate by category.

 

For example, I want the meter GPS coordinate to be red and transformer GPS location to be green on the map. However, when I tried to do that red and green appeared in the same location.

 

Anyone know what is the best solution to this problem?

 

I have attached screen shots below for references.

 

Much appreciated. 

 

 

GPS.PNGGPS2.PNG

2 ACCEPTED SOLUTIONS

Accepted Solutions
Highlighted
Super User
Super User

Re: How to color code different GPS coordinates by category?

@datadude28 You have 2 options => for both you'll need a Column (e.g. Column = 1 and drag it to the size)

 

For option 1 you'll have to change the aggregation of Lat and Long to Sum or Avg it won't matter

Map Categories 1.png

 

Pictures are pretty self explanatory - let me know if you have any questions.

 

Hope this helps!

 

and here's option 2

 

Map Categories 2.png

Super User
Super User

Re: How to color code different GPS coordinates by category?

I have no way of knowing what your data looks like?

 

I answered based on the limited data you originally posted - however PBI can in fact plot ALL your data!

 

Map Categories 4.png

And here it is Zoomed

Map Categories 5.png

 

 

10 REPLIES 10
Super User
Super User

Re: How to color code different GPS coordinates by category?

@datadude28 Isn't that is what is happening currently ? You're getting green for one category and red for another. They both appear in same location because you would have same location in your data for both the categories.

 

anithat Regular Visitor
Regular Visitor

Re: How to color code different GPS coordinates by category?

Hi @datadude28, I agree with Ankit. Please check the data, both transformer and meter coordinates should be pointing to the same location in this case.

 

 

datadude28 Frequent Visitor
Frequent Visitor

Re: How to color code different GPS coordinates by category?

One the map it is not showing correctedly. 

 

The map should show one GPS coordinate to be red and the other green but instead its showing 50% green and 50% red on the same GPS coordinate.

 

Hope you can see what is the problem is now.

datadude28 Frequent Visitor
Frequent Visitor

Re: How to color code different GPS coordinates by category?

As you can see the meter and transformer is at a different location.

 

 

gps.PNG

 

Highlighted
Super User
Super User

Re: How to color code different GPS coordinates by category?

@datadude28 You have 2 options => for both you'll need a Column (e.g. Column = 1 and drag it to the size)

 

For option 1 you'll have to change the aggregation of Lat and Long to Sum or Avg it won't matter

Map Categories 1.png

 

Pictures are pretty self explanatory - let me know if you have any questions.

 

Hope this helps!

 

and here's option 2

 

Map Categories 2.png

datadude28 Frequent Visitor
Frequent Visitor

Re: How to color code different GPS coordinates by category?

Oh wow thanks for that. I didnt know it worked as soon as I put put category under the location property.

Super User
Super User

Re: How to color code different GPS coordinates by category?

@datadude28 

Yes I prerfer option 1 because when you turn on category labels - they are better (more meaningful) than the lat, long coordinates

You can get creative there and even concatenate some fields to display more with the Labels...

 

Map Categories 3.png

 

anithat Regular Visitor
Regular Visitor

Re: How to color code different GPS coordinates by category?

Hi @datadude28, After seeing the data and trying it on my PBID, I would suggest to please use the option 2 from Sean's Answer.

 

Count of ID in the Size tab should do all the trick for you.

datadude28 Frequent Visitor
Frequent Visitor

Re: How to color code different GPS coordinates by category?

Actually I did some further testing it seems to not work for multiple coordinates. The coordinate must be aggregated such as using sum or avg which really doesnt make sense.

 

Therefore, it did not work when I had mutiple coordinates for transformers and meters.

 

gps.PNG

 

Data.PNG