How can I connect two columns from two separate tables together?

[Natasha93]

Hi, I'll start of by saying I'm new to Power BI, my skills are at a beginner level.

I have been tasked with creating a report that pulls data from two different data sources (Palantir Foundry.)

Table 1 - data on count of operational tickets (with their unique IDs), focusing on services (hardware support, maintenance and repairs, training), who those tickets where resolved by (assignment groups), the date they were resolved and what channel they came in from (phone, chat, email, portal.)

Table 2 - feedback on those services and their survey scores. Each feedback survey creates their own unique ID that does not match the operational ticket ID.

My report visuals displays data from both tables, but I would need them both to be linked.

For example,

Visual 1 has Table 1 data; when I highlight a service, it should show the feedback in Visual 2 from Table 2 data.

My understanding is that I would need to link the "Service" columns in both tables. However, these columns do not contain unique values.

Is there a way I am able to connect the Service columns from both tables so that the filter for Services works for both visuals?

(Note: due to my companies data protection policies, I would not be able to provide the file data in any form. Sorry, I know this would help a lot with solving this.)

[Anonymous · Accepted solution]

Hi @Natasha93 ,

Suppose I have these two tables.

Table1.

Table2.

Please create a bridge table.

Table3 = VALUES(Table1[Services])

 Then create the relationship.

Finally use the field [Services] from Table3 in the two visuals.

The PBIX file is attached for reference.

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly -- How to provide sample data

[Seanan]

Hi @Natasha93 

If you navigate to the Model tab in PowerBI (see screenshot) and click manage relationships, you can create a relationship between both service columns.

In the manage relationships tab, click new -> select table1 in the drop down and click the service column and do the same for table2. Click ok and this should like the tables together via the service column.