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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
duncanmci
Regular Visitor

Map Visualisation - Location not unique - Alternate Primary Key

I have a situation where I have multiple customers at the exact same physical location. For example:

 

Location ID     Customer Address                                    Customer Name

1234               200 Queen Street, Brisbane Qld 4000       ABC Company Pty Ltd

9876               200 Queen Street, Brisbane Qld 4000       XYZ Company Pty Ltd

 

On a map object, the Location (i.e. the Customer Address) appears to be considered the Primary Key, but as this example demonstrates, the Customer Address by itself is not unique.


I have Sales data in one table, and Customer data in another table, with the Primary Key of the Customer table being "Location ID". As you can see from the above example, the Location ID is unique, but the physical address is not.


When mapping customer sales, the tooltip will display the incorrect Customer Name (First/Last) and Location ID (Sum/Count/Min/Max etc). 


If I were to create a composite key with Location ID (or other), then the address would not map correctly – it would be an invalid address.


Without merging the datasets (massive amounts of duplicated data – that’s why we have a data model), is there a way to set an alternate Primary Key on the Map object so that the correct customer details are shown?


As properties/addresses change hands, this is also problematic when considering historical data.

3 REPLIES 3
v-kelly-msft
Community Support
Community Support

Hi @duncanmci ,

 

Try to put "Location ID " in the "legend" of the map view.

16.png 

 

Best Regards,
Kelly

Thanks but no that doesn't work either. Irrespective, I need the Legend to represent a geographic region and having thousands of items in a legend (individual addresses) is a bit of overkill.

Anonymous
Not applicable

@duncanmci Would adding an index column be a way to achieve this?

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

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

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.