Forum Discussion
Categorize a single point on a map
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.
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
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
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.
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.
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..
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.