Forum Discussion
Help with displaying data from 2 different tables in same chart
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,
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
6 Replies
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.
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])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
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
