Skip to main content
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

New Member

Power BI

Hello everyone!

I have a problem with the Map. I used Dataverse to get my data working on directquery. I need only Data for new Zealand but the problem is some bubbles are being shown in other countries with new Zealand details. How can I get rid of those bubbles in other continents. I have country, region, city/town and street. I put all of them. I filtered only new Zealand. But still I can't help.  Please find attached the picture



Super User
Super User

Hi @Uzair011 ,


There's a possibility that those locations exist other than in NZ.  Just the name of the place is not reliable so in my personal project, I built a table of geo coordinates from scratch but took a very long time to finish. There are already posts similar to this which may help you solve your problem. These are just samples: 

Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

"Tell me and I’ll forget; show me and I may remember; involve me and I’ll understand."
Need Power BI consultation, get in touch with me on LinkedIn or hire me on UpWork.
Learn with me on YouTube @DAXJutsu or follow my page on Facebook @DAXJutsuPBI.

Helpful resources

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.


Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.