Forum Discussion
Connect data from different datasets
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?
3 Replies
Hi Anonymous ,
Create a relationship on DATASET2[Organization] colmn and DATASET1[Organization] column.
thanks,
Pragati
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
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
