Employee home address vs working address, map

[Reykjavik]

Hi,

I am new to this forum and new in Power BI,

I have recently finish my first course.

Now I want to see where my employees live and where they work.

In my map I want to see John in one colour (two dots, home and work address), Alice in another colour (two dots).

I have made three tables, which are connected.

Table 1, staff name

Table 2, staff name and home address

Table 3, staff name and working address

I get the dots right, at right places.

What I  don't get right.

If I choose "John" I only get his home address or his working address. Not both, as I wished for.

See attachment. Black dot is right, but I want another black dot to show his working address (black circle with yellow line).

[MFelix · Accepted solution]

Hi @Reykjavik,

Believe that this is an issue for the relationship betwen both tables that have home and work adress.

I created a table with 3 column (kept the Staff table as a connection):

• Staff
• Adress
• Type - Work / Home

Then added:

• Adress - Location
• Staff (related table) - Legend
• Type - Tooltip

As you can see below I have two dots for each and stoping on one gives me the detail if it's home or work.

Regards,

MFelix

[Reykjavik]

Great MFelix,

Thank you