Forum Discussion
Overlapping Scatter plot for 2 independent tables
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?
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.
2 Replies
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-8e3eccb41bdaPower BI- Power Query: When I asked you to create common tables: https://youtu.be/PqfGW6pl1Sw
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.
