Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to 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
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
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.
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.
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
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.
As you can see the meter and transformer is at a different location.
@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
Oh wow thanks for that. I didnt know it worked as soon as I put put category under the location property.
@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...
@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.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
98 | |
86 | |
70 | |
62 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |