Map Visual

I think you need to 1) create a new location column which stores your locations in a rigth format (how to is in this article, below section "Create a separate Location column in your data").

2) Add location to your map: step step is to show the circles on the map

Then drag your newly created column to the "Location" box on your chart (based on your screenshot you have 2 fields right now in this, you replace those two to the new one).

3) Add legend - this step will do the coloring on your chart

I guess that your STREET/AVEN column cotains only binary values (e.g: street or avenue).

You need to drag&drop this column to the Legend attribute of the map.

If it's not the case than you ned to create a column with such breakdown and use that.