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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
sks2701
Helper III
Helper III

Using Map functionality

Hi - Please find  list of companies against each city - I want to plot these companies in the map using power bi - please note majority of the cities are US based , however there are few which are Non - US , so below are my requirements

 

1) plot companies based on cities ( for some city there are more than one company)

2) Can we also put a filter which will show only US companies 

 

thank you!

 

companyHQ City
AccelyaBarcelona
AcquiaBOSTON
AdvancedSLOUGH
AlegeusWALTHAM
AlertMediaAUSTIN
Allvue SystemsMIAMI
ApplauseFRAMINGHAM
ApptioBELLEVUE
Aptean, Inc.ALPHARETTA
ARCOSCOLUMBUS
Assent ComplianceOTTAWA
AvalaraSEATTLE
BetterCloudNEW YORK
BigTimeCHICAGO
BlueConicBOSTON
BonterraAUSTIN
CentralSquare TechnologiesLAKE MARY
Cloud Software GroupFORT LAUDERDALE
COMPLYNEW YORK
Critical StartPLANO
CventTYSONS CORNER
DispatchBOSTON
DriftBOSTON
EABWASHINGTON
EagleView Technology CorporationBELLEVUE
EllucianRESTON
ESO SolutionsAUSTIN
FinastraLONDON
FLASHAUSTIN
Fusion Risk ManagementROLLING MEADOWS
GainsightSAN FRANCISCO
GranicusDENVER
Greenway Health, LLCTAMPA
IcimsHOLMDEL
iN2LGREENWOOD VILLAGE
Infoblox, IncSANTA CLARA
Integral Ad ScienceNEW YORK
JamfMINNEAPOLIS
JebbitBOSTON
JioMUMBAI
KhorosAUSTIN
KiboDALLAS
KlarnaSTOCKHOLM
KnowBe4CLEARWATER
LogicMonitorSANTA BARBARA
LucidSOUTH JORDAN
mablBOSTON
MedTrainerLAS VEGAS
Menlo SecurityMOUNTAIN VIEW
MINDBODYSAN LUIS OBISPO
NAVEXLAKE OSWEGO
NavigaBLOOMINGTON
OfficeSpaceALPHARETTA
OliveCOLUMBUS
PipedriveTALLINN
PlanSourceORLANDO
PluralsightDRAPER
PoppuloDENVER
Power FactorsCOSTA MESA
PowerSchoolFOLSOM
QuickbaseCAMBRIDGE
RadarFirstPORTLAND
SalesloftATLANTA
SchooxAUSTIN
SecuronixADDISON
SmartBearSOMERVILLE
SoleraWESTLAKE
SonatypeFULTON
StarRezMELBOURNE
Stats PerformCHICAGO
TigerConnectSANTA MONICA
Tribute TechnologyMIDDLETON
Trintech, IncADDISON
TripleLiftNEW YORK
TripleseatCONCORD
Vena SolutionsTORONTO
Vivid SeatsCHICAGO
WorkTangoAUSTIN
Xactly CorporationSAN JOSE
Zapproved LLCPORTLAND
1 REPLY 1
TomMartens
Super User
Super User

Hey @sks2701 ,

 

I recommend reading this whitepaper: Exploring Maps in Power BI Whitepaper | BlueGranite
Even if this is an older document, it still holds true.
Regarding your 2nd question: as soon as you have added a country column, you can only filter for US companies. There are no "auto-generated" columns containing spatial information.

Regarding you first question, what is your expectation, do you expect that each company will appear as a datapoint?

As you can see, visualizing spatial information comes with some extra challenges:
image.png
If you follow this link: Cities named Orlando. How many places are named Orlando? (geotargit.com)
the result shown in the above Azure map is of no surprise.

Hopefully, this gets you started
Tom



Did I answer your question? Mark my post as a solution, this will help others!

Proud to be a Super User!
I accept Kudos 😉
Hamburg, Germany

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.