How to color code different GPS coordinates by category?

[Anonymous]

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. 

[Sean · Accepted solution]

@Anonymous 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

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

Hope this helps!

and here's option 2

[anithat]

Hi @Anonymous, 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.

[Anonymous]

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.

[Sean · Accepted solution]

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!

And here it is Zoomed

[anithat]

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

[Anonymous]

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

[Sean · Accepted solution]

@Anonymous 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

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

Hope this helps!

and here's option 2

[Anonymous]

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

[Sean]

@Anonymous 

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...

[ankitpatira]

@Anonymous 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.

[Anonymous]

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.