The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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,
Solved! Go to 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
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 |
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
@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])
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.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
94 | |
94 | |
86 | |
69 | |
65 |
User | Count |
---|---|
240 | |
125 | |
122 | |
82 | |
80 |