Forum Discussion
How to handle wonky address data?
I have a dataset of addresses. I noticed that some of the addresses are partially incorrect. For example, one address has the correct city, state, and zip of Fairbanks, AK 99664, but the street address is actually for an address in Seattle. The map will show plot that point in Deland, FL which is way off base.
I'm not sure how to handle problematic data like this, but it makes me look bad when it gets plotted in a random state. Anyone have any advice on how to handle these situations? Is there a way to just eliminate addresses from the map if the address doesn't make sense? Or is there a way to at least show them in the noted city and state? Like, can I establish a hierarchy to plot it in the correct state, city, street address in that order?
1 Reply
you will want to clearly declare the geo category for each of your columns, to help Power BI decide. So the field that contains "AK" should be marked as "State/Province".
In addition you could prefilter your data using an address resolution service either in Power Query or before. But this may be both slow and costly.
