Connect data from different datasets

[Anonymous]

Hi,

I have several datasets that I need to connect together to visualize and filter in the same figure.

The datasets look similar to this:

DATASET 1

Organization	Exposure hours	...(other columns)
A	100	...
B	140	...
C	130	...
D	160	...

DATASET 2

Organization	Exposure hours	... (other columns)
E	240	...

I have a figure that shows the exposure hours for the different organizations in the dataset with the ability to filter on them. However, I now want to include organization E from dataset 2 into the same visualization, and being able to filter.

I assume I have to do something with relationships, but I haven't been able to solve it from what I've tried so far. Any suggestions? 

[Anonymous]

Hi @Anonymous ,

What's your desired result? Whether below table is what you want? Do DATASET1 and DATASET2 have the same table structure? If yes, you can combine these two "dataset" into one query using Append Queries in Power Query Editor.

Organization	Exposure hours	...(other olumns)
A	100	...
B	140	...
C	130	...
D	160	...
E	240	...

Merge Vs. Append In Power BI In Power Query Editor
Best Regards

[amitchandak]

@Anonymous , One option it to merge two dataset

https://radacad.com/append-vs-merge-in-power-bi-and-power-query

or create a common /bridge table for organization and use : https://www.youtube.com/watch?v=Bkf35Roman8

[Pragati11]

Hi @Anonymous ,

Create a relationship on DATASET2[Organization] colmn and DATASET1[Organization] column.

thanks,

Pragati