Mapping Addresses

[TabathaN]

I am having a hard time finding a way that I can map addresses for my patient population. I've had a request come through where marketing would like to see our 2018 patient population by their home address. I (think) one of the problems I have is that my 2018 patient population is roughly 39K so that is a lot, possibly too many, points to map.

Does anyone have suggestions on map type or ways to structure my data to make this possible? At first I was thinking some type of heat map might work well but I'm open to suggestions!

I have already modeled the address fields with approrpriate data categories but I currently do not have any Lat or Long data in my tables.

Also, I cannot share my data due to HIPAA privacy but I can do my best to answer any questions you may have in order to help me. 

[v-piga-msft]

Hi @TabathaN ,

What map visual do you use currently in Power BI?

It's hard for us to suggest you, because we don't know what is your desired output. You could have a good look at this document to choose the most suits your scenario. 

In addition, if you think your datapoint is too much, I'll suggest you could create a Hierarchy and then create the map visual with the hierarchy.

Best Regards,

Cherry

[TabathaN]

@v-piga-msft 

Thank you for your reply.

Currently I'm not really using any visual because nothing I'm doing is giving me favorable results. I think some type of filled map or heat map might be the right direction though. I like the ability to do a hierarchy so they can drill down by zip, city then hopfully down to specific address.

I think some key questions that remain unanswered are:

1) it seems as though using Lat/Long is the preferred/suggested way to plot addresses in maps and may improve performance. If my data does not have Lat/Long data - how can I go about adding this?

2) Should a map be able to support plotting 40K addresses on a map? Or will we be forced to filter down the data?