I would like to create a map using that shows all of our competitors in a bubble pie chart with the size determined by revenue, as well as a separate bubble for our offices. I'd like to see how our revenue compares to our competitors in that state.
This visual below is using Azure map and a bubble layer. It is very close to what I am looking for but it places our offices inside the pie chart with the competitors. I would like our office to have their own bubble separate from others. Is this possible? If so, could someone please help.
My data at the moment has a column for Company names which includes our offices. I do have another column that separate Competitor and Office Location as well. Any suggestions would be greatly appraciated.
