Map tool - How to show two locations under same address.

[Anonymous]

Hello

I am using the map tool to locate all our clinics thru their addresses, as well, I'm using a Tooltip tab to show specific informations when hovering over the bubbles.

I have some clinics that have the same address but different suite numbers. For those cases, currently the map is showing, under that address, just one bubble and the tooltip is showing the info just for one of the locations.  The other clinic  under the same address is not showing unless a filter is applied that doesn't include the other one.

How can I make the map to show two bubbles instead of one or at least how can make the tooltyip to show there are two clinics associated to the same bubble??

[v-chuncz-msft · Accepted solution]

@Anonymous 

You may use CONCATENATEX to add a measure.

https://community.powerbi.com/t5/Desktop/split-by-delimiter/td-p/363277