Need Help with Respect to Map visual data alignment

[Nitin21]

Power Bi Requirement -

A)When selecting an Employee name slicer, the map will shows:

1)The Employee location.
2)All Customers associated with that Employee with respective sale

B)When selecting a Product Line, the map should:

1)should not remove selected employee as well as associated customers.
2)should Show all additional customers related to that Product Line.

As client just want to check which Product line customer is near to that particular Employee

[v-sgandrathi]

Hi @Nitin21,

Thank you for using Microsoft Fabric Community Forum and also Thankyou @rajendraongole1 for your response.

When selecting an Employee in the slicer, the map should display:

The employee's location, all customers associated with that employee, and their respective sales amounts (bubble sizes).

When selecting a Product Line, the map should:

Keep the selected employee and their associated customers visible, add additional customers related to the product line, even if they are not connected to the employee.

This setup ensures the client can see both the employee's data and the customers in proximity to the employee, including those associated with the product line.

To dynamically control which customers are shown based on slicer selections, you can use DAX measures:

A DAX measure for Product Line filter will help display customers related to the selected product line. A DAX measure for Employee and Customer filter ensures that the selected employee and their customers remain visible, even when the Product Line slicer is applied.

Additionally, applying visual-level filters will ensure that only relevant customers are displayed without removing the employee's data or their associated customers.

I hope these suggestions provide you with a clear understanding of the query.

Please Accept as solution if this meets your needs and a Kudos would be appreciated.

[v-sgandrathi]

Hi @Nitin21,

May I ask if you have gotten this issue resolved?

If it is solved, please mark the helpful reply or share your solution and accept it as solution, it will be helpful for other members of the community who have similar problems as yours to solve it faster.

Thank you.

[v-sgandrathi]

Hi @Nitin21,

I wanted to check in your situation regarding the issue. Have you resolved it? If you have, please consider marking the reply as Accepted solution and give Kudos that helped you. It would be greatly appreciated by others in the community who may have the same question.

Thank you for using Microsoft Community Forum.

[v-sgandrathi]

Hi @Nitin21,

Following up to check whether you got a chance to review the suggestions given. If the issue still persists please let us know. Glad to help

If our response has addressed your query, please accept it as a solution and give a ‘Kudos’ so other members can easily find it. 

Thank you.

[rajendraongole1]

Hi @Nitin21  - the relationship should be:

Employee Table → Customer Table (One-to-Many) based on EmployeeID

Customer Table → Sales Table (One-to-Many) based on CustomerID

Add a Map (or ArcGIS Map) visualization.Use Customer Location and Employee Location as map points.Use Sale Amount as a size indicator (bubble size).

Power BI MAP Visualization: Must-Know PBI MasterClass!!!

Measure to filter a visual based on slicer selections : r/PowerBI

Tips and Tricks for maps (including Bing Maps integration) - Power BI | Microsoft Learn

youtube.com/watch?v=K6tOsDoZ20c