Categorize a single point on a map

[tonykeats]

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.

[v-qiuyu-msft]

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 Yu

[tonykeats]

Qiuyun 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

[Seth_C_Bauer]

@tonykeats Off the cuff (don't know if it would work) you could create a column/calculated column to determine job sites and with values of 1 for job site 0 for others. Then use that as a legend.. 

[deldersveld]

I don't think Legend would work as a 0/1 column still creates the pie chart with split colors. Color Saturation works for a uniform color though.

[deldersveld · Accepted solution]

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.

[tonykeats]

Yes! I had to do some finagling and build a table that had a single column containing both addresses and an ID so i could join it back to the original table. Then I added the flag of 1 or 0. It's working perfectly. what a great end result to my first post. Thanks so much! attached screenshot for your viewing pleasure. 

-Tony

Side note your olympic bid rpt is cool.