Showing a Location ID with multiple values

[gfarris1]

So hopefully I put the correct heading on this.  I am in the process of trying to consolidate some alignments with servicing companies.  I want the tooltip to just display the location when i hover over it.

I am using two data sets, one is a list of providers, their rank and trade they service so it would look like below.

Store	Provider	Service	Rank
5050	xyw	Landscaping	1
5050	xyz	Landscaping	2
5050	hty	Landscaping	3
5050	ksvw	Landscaping	4
5050	khjdu	Landscaping	5
5050	jsbsg	Landscaping	6
5050	shdfg	Landscaping	7

The second table is all of the location information, lat and long, city, etc.  The tables are connected via store number.

So the stores are mapped, the providers are in the legend (So when I sort by a trade it shows how they populate on the map), once I add the Store number to the tooltip all of the locations dissapear except for a few.  If I drill down to specific trade and state, it shows correctly.  I dont need the tooltip field to be calculated.  Hopefully this makes sense thank you!!!

[v-juanli-msft]

Hi @gfarris1

Is data type of your Store column whole number?

As tested, when it is whole number, add it in the tootip, it should be count as sum, count,ect.

when it is test, it show the first store by default.

once I add the Store number to the tooltip all of the locations dissapear except for a few. 

How do you add columns and measures in your map visual, could you share a screenshot of the map visual and Fields pane as my picture above?

Besides, please check if the table where the store column added in the tooltips field lies have less kinds of stores than another table.

Best Regards

maggie