- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Comparing Addresses for Mapping
Hello,
I am working to map out various clinical sites to show visually how many different companies are using a single clinical site.
I am receiving a lot of address data from a few different companies and compiling it together in a single exel spreadsheet.
I sort the addressses into columns: Country, State, City, Zip, Address. I also have my Location block in PowerBI Map set to this, drilled down to adderss, and my legend set to Company. Each data category is caterogrized correctly as well.
I have noticed that unless the two address are exactly the same, they won't share a bubble in the PowerBI map, and it will only show as one company using that address.
For example:
These are clearly the same address, however only one bubble shows up for company X. I am getting a ton of data and don't have time to sift through all of them to make sure they are all exactly the same, and I am getting updates to this list about once a week.
Company | Clinical Site | Country | State | City | Zip | Address |
X | A | USA | Kansas | Wichita | 67205 | 2260 S. Break Road |
Y | B | USA | Kansas | Wichita | 67205 | 2260 South Break Rd. |
What am I doing wrong? Is there a better way to approach this?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

what are you expecting to see, them on the same bubble, if so then you can't have the legend set to company. its hard to know without seeing what you have set up and how.
If I took the time to answer your question and I came up with a solution, please mark my post as a solution and /or give kudos freely for the effort 🙂 Thank you!
Proud to be a Super User!

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
03-07-2017 09:14 PM | |||
08-22-2024 11:56 PM | |||
07-30-2017 09:53 PM | |||
01-13-2022 04:57 AM | |||
Anonymous
| 09-13-2022 05:26 AM |
User | Count |
---|---|
141 | |
115 | |
84 | |
63 | |
48 |