Connecting One Maps Location to many other Locations(Base Stations to clients)

[Anonymous]

I have connectivity data. I have two tables and the following columns. 

For the clients' table, A client May have many sites.  and each site has its own coordinates as shown below

Clients Table

Client		Site		Base Station Name		Client_latitude		Client_longitude
Client A		Site A		BS A		0.0034		34.3435
Client A		Site B		BS B		1.45434		36.56454
Client B		Site A		BS B		2.343534		31.45439
Client B		Site B		BS C		-1.8524		34.50053
Client B		Site C		BS A		0.4443223		35.4543223
Client B		Site D		BS D		0.4533134		38.556343
Client C		Site A		BS F		1.3855342		36.334353
CLient C		Site B		BS B		1.009995		0.098757

For the base stations, they are just the coordinates and names of the BS as shown below. 

Base Stations Table

Base Stations		BS_lat		BS_long
BS A		1.35876		33.55634
BS B		2.34632		34.74545
BS C		1.54632		35.57997
BS D		1.64325		32.56577
BS E		0.454326		31.0000
BS F		0.674236		32.88989

So the ask at hand is to connect the base stations with some sort of lines to show which clients are being served by which Base stations. 

e.g. BS A (Base Station A) should be located on a map with its coordinates and have two lines connecting Site A of CLient A and
site C of Client B. 

Base Station B should have 3 sites connected to it. 
How do I achieve this

[Anonymous]

Hi @Anonymous ,

Line and Clustered Column Chart are available in visualizations pane.

[Anonymous]

Hi @Anonymous ,

try below steps

1. Load your tables into Power BI: Import both the Clients table and the Base Stations table into Power BI as separate tables.

2. Create a relationship: Create a relationship between the "Base Stations" column in the Clients table and the "Base Stations" column in the Base Stations table. This relationship will allow you to connect the two tables based on the common values in the Base Stations column.

3. Add a map visual: Add a map visual to your Power BI report canvas. You can find the map visual under the "Visualizations" pane.

4. Configure the map visual: Drag the "BS_lat" column from the Base Stations table to the "Location" field well of the map visual. This will plot the base stations on the map based on their latitude and longitude coordinates.

5. Add lines between base stations and client sites: To connect the client sites to the corresponding base stations, you can use the "Line and Clustered Column Chart" custom visual in Power BI. You can download this visual from the Power BI Marketplace.

   a. Once installed, add the Line and Clustered Column Chart visual to your report canvas. b. Drag the "Client_latitude" and "Client_longitude" columns from the Clients table to the "X Axis" and "Y Axis" field wells of the visual. c. Drag the "Base Stations" column from the Clients table to the "Legend" field well. d. You should now see lines connecting the client sites to their respective base stations on the map.

6. Format the visuals: Format the map visual and the Line and Clustered Column Chart visual as per your requirements, adjusting colors, line styles, and labels to make the visualization more visually appealing and informative.

Please Accept as Solution if resolved your problem!!

[Anonymous]

I am on point 5 and can't seem to find Line and Clustered Column Chart on Power BI service..