Map visual in power bi help

[DiKi-I]

Hi , this is the sample data which I have created. I need to plot this in map. The premise_name_from column will be in the slicer so user can select one premise and can see how many other premise are around it, I want to highlight the from premise_name_from in the map is it possible? Is it possible to plot lat_from ,lon_from as well as lat_to and lon_to( these are latitude and longitude)

premise_id_from premise_name_from lat_from lon_from premise_id_to premise_name_to lat_to lon_to

A000001-001	Alpha Café	40.7128	-74.0060	B000101-001	Beta Store	34.0522	-118.2437
A000001-002	Alpha Café	40.7128	-74.0060	B000101-002	Gamma Market	41.8781	-87.6298
A000002-001	Delta Deli	37.7749	-122.4194	B000102-001	Epsilon Foods	29.7604	-95.3698
A000002-002	Delta Deli	37.7749	-122.4194	B000102-002	Zeta Café	39.9526	-75.1652
A000003-001	Omega Grill	47.6062	-122.3321	B000103-001	Sigma Kitchen	32.7157	-117.1611

[v-karpurapud]

Hi @DiKi-I 

Just checking in as we haven't received a response to our previous message. Were you able to review the information above? Let us know if you have any additional questions.

Thank You.

[v-karpurapud]

Hi @DiKi-I 

We have not received a response from you regarding the query and were following up to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions.

Thank You.

[v-karpurapud]

Hi @DiKi-I 

I wanted to check if you’ve had a chance to review the information provided. If you have any further questions, please let us know. Has your issue been resolved? If not, please share more details so we can assist you further.

Thank You.

[v-karpurapud · Accepted solution]

Hi @DiKi-I 

Thank you for reaching out to the Microsoft Fabric Community Forum.

I have reproduced the scenario on my end using the sample data, and the solution is working as expected. The setup allows you to select an origin premise from the slicer, which highlights the selected premise prominently on the map while also displaying all of its connected destination premises around it. To help you better understand the implementation I have prepared and attached a sample .pbix file and snapshot that demonstrates the full implementation. Please review the attached file at your convenience and share your observations so we can refine the solution further if needed.

I hope this information is helpful. . If you have any further questions, please let us know. we can assist you further.

Regards,

Microsoft Fabric Community Support Team.

[DiKi-I]

Thanks for the example. I'm able to do this but then I'm not able to add kpi to show the size of bubble, either it can be point size or kpi. I have kpi for each premise, which shows the no of transactions. I want to show that also in the map.

[v-karpurapud]

Hi @DiKi-I 

I have updated the .pbix file to include the KPI transactions so that the bubble size on the map now represents the number of transactions for each premise. This enhancement allows you to visually identify which premises have higher or lower transaction volumes based on the bubble size. Please review the updated file and let me know if this meets your requirement or if any further adjustments are needed.
 

Regards,

Microsoft Fabric Community Support Team.

[Poojara_D12]

Hi @DiKi-I 

You can absolutely achieve this in Power BI by plotting both the origin and destination coordinates on a map and highlighting the selected “from” premise. Your table already contains the necessary latitude and longitude values for both sides, so the setup is straightforward. Place premise_name_from in a slicer so that when a user selects one premise, only its related rows remain. Then, on a map visual such as Azure Maps, use lat_from/lon_from for the origin and lat_to/lon_to for the destinations, and create a simple category or calculated column (e.g., “From Premise” vs. “To Premise”) to assign different colors, ensuring the origin stands out from the connected locations. This way, the chosen premise is clearly highlighted, while all other premises linked to it are displayed around it. If you want to go further, Azure Maps or custom visuals like Icon Map also allow you to draw connecting lines, showing the flow from the selected origin to its destinations, which makes the visualization even more intuitive.

[DiKi-I]

how the orgin and destination can be set up in azure map? Can you please provide an example or demo file?

[NimaiAhluwalia]

Hello @DiKi-I 

I am speaking out of experience, never tried this, but it's worth trying!

Yes, you can plot both. But Power BI maps expect one pair of lat/lon per row. Since your table has two pairs, you need to reshape the data.

Solution:

• Create a “Point Type” column = "From" and "To".

• Create a unified Latitude and Longitude column.

• This way, each row can be either the “from” point or the “to” point.

Steps:

• Add PointType to the Legend field in your Map visual.

• This will give two categories: From and To.

• Power BI will color them differently

• Place premise_name_from in a slicer.

• When a user selects “Alpha Café”, the map will:

  • Show Alpha Café (highlighted as “From”).

  • Show all connected premises (the “To” points)