Overlapping Scatter plot for 2 independent tables

[Anonymous]

I have two independent tables, Table A and Table B. Both tables have the same columns: Column 1 and Column 2. Now, I want to combine the data from Column 1 of both tables on the X-axis and the data from Column 2 on the Y-axis. Can someone please guide me on how I can do this?

[v-yanjiang-msft · Accepted solution]

Hi @Anonymous ,

By my test, it can't be realized in one plot with two seperate tables. To do that, we can firstly append the two tables in Power Query. If you don't want to change the original tables, select "Append Queries as New".

Best regards,

Community Support Team_yanjiang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Anonymous , You need to create common dimensions

Power BI- DAX: When I asked you to create common tables: https://youtu.be/a2CrqCA9geM
https://medium.com/@amitchandak/power-bi-when-i-asked-you-to-create-common-tables-a-quick-dax-solution-8e3eccb41bda

Power BI- Power Query: When I asked you to create common tables: https://youtu.be/PqfGW6pl1Sw