How to combine two column from two different table into one.

[asta]

I have created a two different distinct column from two different table, now i want to show in my chart the combine sales value from both tble and want to combine those two distinct column into one..how do i do that.

For example in my chart i am showing the total sales value (Table A Sales+TableBSales) from both the table, now i want to show in legend the combine category name, but i am not able to do that

any idea how to do that?

[v-sihou-msft · Accepted solution]

@asta

Merge Queries is like joining two different tables. For your requirement, you should use "Append Queries" to combine two colums values into one. Please see: Shape and combine data in Power BI Desktop

Regards,

[ankitpatira]

@asta in power bi desktop query editor use Merge Queries to combine two tables into one. Then you can use that single table for visuals.