Create a line chart by using a column value combined from two table

[nj17]

Hi All,

I need to create a line chart based on a column.I have this column in two of my tables.now I want all the values for this particular column from these two tables on a single line.

How can I do this.

I know I can Combine these tables in Power Query.

Thanks

[Pragati11 · Accepted solution]

Hi @nj17 ,

You have already answer to your query - appending these 2 tables into a single table in Power BI 🙂

Then use the column on line chart.

Just make sure that the column names in both the tables should be same.

Thanks,

Pragati

[v-cazheng-msft · Accepted solution]

Hi, @nj17 

If you want to use values from columns in two tables into one single line, you need to create a new table based on these two tables. According to the structure of your tables, you can use Merge or Append in Power Query Editor or CROSSJOIN or Union in Desktop.

Best Regards,

Caiyun Zheng

Is that the answer you're looking for? If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Pragati11 · Accepted solution]

Hi @nj17 ,

You have already answer to your query - appending these 2 tables into a single table in Power BI 🙂

Then use the column on line chart.

Just make sure that the column names in both the tables should be same.

Thanks,

Pragati

[nj17]

Hi @Pragati11 Is there any other way something if we can create a measure where it will return the total values of this column from both the tables.Beacause through appending query it creates a new dataset.

Thanks

[Pragati11]

Hi @nj17 ,

this will completly depend on what you are trying to plot on your line chart.

Add details and some screenshots on what you are trying to achieve.

Thanks,

Pragati