Which visual for polylines and points

[JensHfors]

Hello

I'm looking for some input on which method/approach is best, or if it is at all feasible to do this. 

I have some rivers as polylines in shape (.shp) format, which I can convert depending on what is needed (read somewhere about TopoJson). I also have outlets to those rivers as points. Is it possible without using some custom visual to show these on the same Map Visual? So fx. I can see the streams with points and a background. There may be relevant data I would like to color by for both polylines and points. 

Should be noted that I'm in Denmark, so some background/functions aren't easy to get by default. 

Any suggestions or workflow suggestions would be welcome. 

Example:

[v-ssriganesh]

Hello @JensHfors,

We hope you're doing well. Could you please confirm whether your issue has been resolved or if you're still facing challenges? Your update will be valuable to the community and may assist others with similar concerns.

Thank you.

[JensHfors]

Hello @v-ssriganesh 

Thank you for the reply and followup!

I've tried opening your PowerBI but this is what I get when opening:

As I see it (and feel free to correct me), the points are averaged when adding a Position layer, which isn't really the look that is needed. When adding the rivers as a referencelayer, everything looks correct, but you loose the dynamic of the rivers in the visual. 

When adding as a reference layer I get the below, rivers are blue and points showing with tooltips etc:

Appreciate the help!

[v-ssriganesh]

Hello @JensHfors,

You are absolutely right when rivers are placed in the Position layer, Azure Maps aggregates the latitude/longitude values, which is why the geometry collapses into single points.

This happens because Azure Maps treats the Position layer as point data unless you provide WKT geometry. By putting the river WKT directly into the Location (WKT) field, the full line geometry is preserved and remains interactive.

So in short:

• Reference Layer → correct river display, but static (no tooltips/filtering).

• Data Layer (WKT) → keeps rivers dynamic and interactive, avoiding the averaging issue.

That’s the tradeoff depending on whether you need static background context or interactive visuals.

we’re glad the issue is now resolved after you added the rivers as a reference layer.

Really appreciate the effort you put into testing different approaches and sharing the screenshots back here. it helps make the discussion clearer and useful for others who may face a similar scenario.

Best regards,
Ganesh Singamshetty

[v-ssriganesh]

Hello @JensHfors,

Hope everything’s going great with you. Just checking in has the issue been resolved or are you still running into problems? Sharing an update can really help others facing the same thing.

Thank you.

[v-ssriganesh]

Hello @JensHfors,
I have reproduced your scenario in Power BI Desktop and I got all the requirements you mentioned:

• Rivers are displayed in the correct location.
• Outlets are plotted with interactive tooltips.
• Both rivers (WKT data) and outlets (latitude/longitude) are shown together in the same Azure Maps visual.
• Bubble sizes and colors reflect your specified measures.

For your reference, I’ve attached the .pbix file containing the working setup.

Best regards,
Ganesh Singamshetty.

[Sandip_Palit]

This is a one-time setup process. Once complete, you can refresh your data without repeating these steps.

Step 1: Convert Your Shapefile (.shp) to WKT
You'll need a standard Geographic Information System (GIS) tool for this conversion. QGIS is a free, open-source, and industry-standard tool that is perfect for this.

Open in QGIS: Add your river Shapefile to a new QGIS project.

Export as CSV: Right-click on your river layer in the Layers panel, then go to Export > Save Features As...

Set Export Options:

Format: Comma Separated Value [CSV]

File name: Choose a location to save your new CSV file.

Layer Options > GEOMETRY: In the dropdown, select AS_WKT. This is the most important setting.

This process will create a CSV file containing all the data associated with your rivers, plus a new column (usually named WKT) that holds the geometry for each river as a LINESTRING(...).

Step 2: Load Your Data into Power BI
Get Data: In Power BI, connect to the CSV file you just created for your rivers.

Get More Data: Also, connect to your other data source that contains the outlet points. This table must have separate columns for Latitude and Longitude.

Step 3: Configure the Azure Map Visual
Add the Azure Map visual to your report canvas.

With the visual selected, configure the Fields pane:

Location (for Rivers): Drag the WKT column from your rivers table into this field well.

Latitude (for Outlets): Drag the Latitude column from your points table here.

Longitude (for Outlets): Drag the Longitude column from your points table here.

Step 4: Add and Format Your Layers
This is where you bring the map to life. Go to the Format your visual (paintbrush icon 🖌️) pane.

Set the Map Background: Go to Map settings > Style and select Satellite or Satellite road labels to get the aerial view.

Enable the Line Layer (Rivers):

Go to the Line layer card and toggle it On. Your rivers should now appear on the map.

Inside this card, you can use the Colors section to set a single color or click the fx button to apply conditional formatting based on another data field.

Enable the Point Layer (Outlets):

The map will likely default to showing your points as a bubble layer. Go to the Bubble layer card to format them.

Just like the line layer, you can go into the Colors option to set a single color or apply data-driven conditional formatting.

By following these steps, you will have a single map visual that dynamically displays both your river polylines and outlet points, with each layer independently colored based on your data.

If this explanation and solution resolve your issue, please like and accept the solution.

[JensHfors]

Thank you for the quick reply. 

I've tried your suggestion, however adding something to Location while also having something in Latitude and Longtitude gives an error suggestiong I remove one of the items. 

Also, when adding the WKT file in Location it shows up as two dots in France for some reason, however adding it as a reference layer it shows up correctly in Denmark just as it should. However as a reference layer I can't show information or anything else with the Rivers.