Line Chart- Multiple Lines Each Based on different table i created

[rashel2002]

Hi Everyone!

I would like to create one Line Chart which based on two different tables (each of them was created from a different query).

there is a way to extract data from two different tables? until now i succeeded to extrct data from one table only, and now i want to merge those two line-chart i got, into one line-chart.

 example-

Currently i have those tables-

PLEASE PAY ATTENTION- i'm looking for a different solution then editing those queries (which are the source of each table i created) into one query!

all i want is create one line from one table, and another line from the second table.

Thanks!!

[v-jiascu-msft]

Hi @rashel2002,

Could you please mark the proper answers as solutions or share the answers?

Best Regards,

Dale

[rashel2002]

I solved it! thanks.

[Greg_Deckler · Accepted solution]

I believe what you want is a third table with just your DISTINCT WW's in it. You then would relate that table to your other two tables and use the WW column from this third table as your axis in your line chart.

[rashel2002]

How do i creat the third table? I need to extract the WW column from one of the queries (as i said i have 2 queries and i created a tables from each of them[two table in total as in the example]). If i choose one of the queries, then when i'll try to put the data from the table made from the other query, it will show a straight line.