Map visual with hours spent/available

[PBI_newuser]

Hi, I would like to plot a map to show the total hours spent in each city based on the date selected.

Each technician has 1560 available hours in a year which means 130 hours per month.

How to plot all these information in a map to see the total hours spent and available hours of each technician in the city?

Table A:

Date	Job#	City	State	Hours Spent
03/01/2020	A-123	Douglaston	New York	7
10/31/2020	B-123	Sparks	Maryland	13
03/01/2021	C-123	Douglaston	New York	17

Table B:

Technician	City	State
Abby	Douglaston	New York
Ben	Sparks	Maryland
Charles	Dallas	Texas
Don	Rochester	New York

[lbendlin · Accepted solution]

Add the available hours as a calculated column to your dataset, and then use it for the bubble size of your location data in the map visual