Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

Reply
Kyle_Wolfe_Ohio
Regular Visitor

Map visual is only showing 1 record at an address when the dataset can have multiple people at 1

I am using the Map visual to display employee locations.  Well, we have a few staff members who are married and at the same address.  Power BI is auto-alphabetizing and only displaying the first person for the address and the selected data I added to the tooltip when I hover over it.  For display and filtering purposes I have implemented, I need to be able to filter/see both people. 

 

Thoughts on work around?

1 ACCEPTED SOLUTION
Anonymous
Not applicable

Hi @Kyle_Wolfe_Ohio ,

You can refer the solution in the following thread to get it:

1. Create a calculated column: You can create a custom column that combines the address and the employee’s name or ID. This will make each location unique, even if multiple employees live at the same address.

Column = [Address] & " " & [Employee Name]

2. Use Category Labels: In the map visual, there is an option called Category Labels. When you turn on this option, Location values, or Latitude and Longitude values will display as labels on the map.  

Solved: Presenting value on the map - Microsoft Fabric Community

Best Regards

View solution in original post

1 REPLY 1
Anonymous
Not applicable

Hi @Kyle_Wolfe_Ohio ,

You can refer the solution in the following thread to get it:

1. Create a calculated column: You can create a custom column that combines the address and the employee’s name or ID. This will make each location unique, even if multiple employees live at the same address.

Column = [Address] & " " & [Employee Name]

2. Use Category Labels: In the map visual, there is an option called Category Labels. When you turn on this option, Location values, or Latitude and Longitude values will display as labels on the map.  

Solved: Presenting value on the map - Microsoft Fabric Community

Best Regards

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.