Help with displaying data from 2 different tables in same chart

[Anonymous]

Hello all,

I have a $ for group a in one table, then $ for group b and $ for group c in a seperate table. Is there an easy way to combine table 1 $ and group name into the values and legend of a line chart? 

Thanks,

[v-yiruan-msft]

Hi @Anonymous ,

If you have the similar structure with my table a and table b in below screenshot, you can apply "Append Queries as New" first. Then drag the related fields from new appended table onto line chart visual.

If the above information is not applicable in your scenario, please provide the related table structure and more sample data(exclude sensitive data).

Best Regards

Rena

[Anonymous]

Source	VP	Account	Period	GSV $			Source	VP	Period	GSV $	Account
2019 Totals	West	Account A	P1	$ 1,000,000.00			Demand	West	P1	$5,000,000	Account A
2019 Totals	West	Account A	P2	$ 2,000,000.00			Field	West	P1	$4,000,000	Account A
2019 Totals	West	Account A	P3	$ 4,000,000.00			Demand	East	P1	$3,000,000	Account B
2019 Totals	East	Account B	P1	$     600,000.00			Field	East	P1	$2,000,000	Account B
2019 Totals	East	Account B	P2	$     700,000.00			Demand	West	P1	$5,000,000	Account C
2019 Totals	East	Account B	P3	$     500,000.00			Field	West	P1	$1,200,000	Account C
2019 Totals	West	Account C	P1	$     400,000.00			Demand	West	P2	$8,700,654	Account A
2019 GSV	West	Account C	P2	$     450,000.00			Field	West	P2	$7,000,000	Account A
2019 GSV	West	Account C	P3	$     600,000.00			Demand	East	P2	$7,500,000	Account B
							Field	East	P2	$8,000,000	Account B
							Demand	West	P2	$8,500,000	Account C
							Field	West	P2	$9,000,000	Account C
							Demand	West	P3	$8,700,654	Account A
							Field	West	P3	$7,000,000	Account A
							Demand	East	P3	$7,500,000	Account B
							Field	East	P3	$8,000,000	Account B
							Demand	West	P3	$8,500,000	Account C
							Field	West	P3	$9,000,000	Account C

[Anonymous]

[v-yiruan-msft · Accepted solution]

Hi @Anonymous ,

According to your provide data, I created one sample pbix file. You can download it from this link and check the details.

Best Regards

Rena

[amitchandak]

@Anonymous 

You can create a new dimesion and join will all three tables
group = distinct(union(all(table1[group1]),all(table2[group2]),all(table3[group3])))

Also you can combine measure from different table
Measure = sum(Table1[Value1]) + sum(Table2[Value2]) + sum(Table3[Value3])

[Greg_Deckler]

Sample data would help. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

You could create an Enter Data query for your groups and relate this to your tables. Or, you might be able to Append all of your tables together. Going to depend.