Forum Discussion
Categorize a single point on a map
I have a table of employees and their home addresses. It also contains addresses of multiple job sites the employee visits. I am using a map to visualize all of their job sites. I'm also using the lat long to figure out the surface distance to each from their home lat long... and it's working great. My question is: Does anyone know a way to overlay the home address on the map and distinguish it from the "job site" addresses. I'm currently showing job sites on one map and emp address on a second map. Assigning a custom color would be ideal.
I did something similar on my Olympic Bid report where the host city was a different color than the other candidate cities. It was accomplished by having a column with a "1" for host and "0" for non-host. You could add a column to your data for an "Home" flag of 1 or 0 (boolean of true/false might work too). From there, try adding that column to the Color Saturation and configure the min/max colors in the Format area.
6 Replies
Hi tonykeats,
In your scenario, you can place the "job site" addresses field in Legend property of home address map. Each home address data point will be divided to different slicers based on the "job site". See:
If you have any question, please feel free to ask.
Best Regards,
Qiuyun YuQiuyun Yu,
Thanks you so much for the response. Although it is not the solution I am looking for... I did find it helpful. It gave me another way to present the data that I had not considered.
I was hoping to plot all the "job site addresses" and have the home address polt amoung them and be distinct in some way. I've attached a screen shot with a current view. I'm not sure there is a way to do this... but thanks again for the tip. It has led me in a good direction with this report.
-Tony
I did something similar on my Olympic Bid report where the host city was a different color than the other candidate cities. It was accomplished by having a column with a "1" for host and "0" for non-host. You could add a column to your data for an "Home" flag of 1 or 0 (boolean of true/false might work too). From there, try adding that column to the Color Saturation and configure the min/max colors in the Format area.
