Forum Discussion
Post PartisanMap visual in power bi help
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.
Continued ContributorHello 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)