Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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!
company | HQ City |
Accelya | Barcelona |
Acquia | BOSTON |
Advanced | SLOUGH |
Alegeus | WALTHAM |
AlertMedia | AUSTIN |
Allvue Systems | MIAMI |
Applause | FRAMINGHAM |
Apptio | BELLEVUE |
Aptean, Inc. | ALPHARETTA |
ARCOS | COLUMBUS |
Assent Compliance | OTTAWA |
Avalara | SEATTLE |
BetterCloud | NEW YORK |
BigTime | CHICAGO |
BlueConic | BOSTON |
Bonterra | AUSTIN |
CentralSquare Technologies | LAKE MARY |
Cloud Software Group | FORT LAUDERDALE |
COMPLY | NEW YORK |
Critical Start | PLANO |
Cvent | TYSONS CORNER |
Dispatch | BOSTON |
Drift | BOSTON |
EAB | WASHINGTON |
EagleView Technology Corporation | BELLEVUE |
Ellucian | RESTON |
ESO Solutions | AUSTIN |
Finastra | LONDON |
FLASH | AUSTIN |
Fusion Risk Management | ROLLING MEADOWS |
Gainsight | SAN FRANCISCO |
Granicus | DENVER |
Greenway Health, LLC | TAMPA |
Icims | HOLMDEL |
iN2L | GREENWOOD VILLAGE |
Infoblox, Inc | SANTA CLARA |
Integral Ad Science | NEW YORK |
Jamf | MINNEAPOLIS |
Jebbit | BOSTON |
Jio | MUMBAI |
Khoros | AUSTIN |
Kibo | DALLAS |
Klarna | STOCKHOLM |
KnowBe4 | CLEARWATER |
LogicMonitor | SANTA BARBARA |
Lucid | SOUTH JORDAN |
mabl | BOSTON |
MedTrainer | LAS VEGAS |
Menlo Security | MOUNTAIN VIEW |
MINDBODY | SAN LUIS OBISPO |
NAVEX | LAKE OSWEGO |
Naviga | BLOOMINGTON |
OfficeSpace | ALPHARETTA |
Olive | COLUMBUS |
Pipedrive | TALLINN |
PlanSource | ORLANDO |
Pluralsight | DRAPER |
Poppulo | DENVER |
Power Factors | COSTA MESA |
PowerSchool | FOLSOM |
Quickbase | CAMBRIDGE |
RadarFirst | PORTLAND |
Salesloft | ATLANTA |
Schoox | AUSTIN |
Securonix | ADDISON |
SmartBear | SOMERVILLE |
Solera | WESTLAKE |
Sonatype | FULTON |
StarRez | MELBOURNE |
Stats Perform | CHICAGO |
TigerConnect | SANTA MONICA |
Tribute Technology | MIDDLETON |
Trintech, Inc | ADDISON |
TripleLift | NEW YORK |
Tripleseat | CONCORD |
Vena Solutions | TORONTO |
Vivid Seats | CHICAGO |
WorkTango | AUSTIN |
Xactly Corporation | SAN JOSE |
Zapproved LLC | PORTLAND |
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:
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
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
135 | |
123 | |
101 | |
71 | |
61 |