Forum Discussion
Merging data from Different tables .
Hello.
I have 5 different tabls with the exact same schema and i am using Direct Query mode. One column in the table represents the Success or Failure. I want to create a pie chart representing the overall Success v/s Failure . How is that possible.
Thank you.
Hi t-taaror ,
If the schema and columns name are same then you can use Append Queries to get all data in single table.
Goto Edit Queries ==> Click on "Append Queries" ==> Select "Three or more tables"
Select the tables which needs to be append. Then click OK. You can create a new table then check the data if that is what you needed.
If this solves your problem mark this as solution and give khudos.
Thanks
3 Replies
t-taaror ,
Yes, in direct query you can create calculate column/measure in the fact table which represents success/failure. Then drag the new column measure and other dimensional columns to a pie chart.
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
hi v-yuta-msft
Actually i am new to PowerBi so could you please elaborate the solution.
The scenario is like for example i have 5 tables each has 10 rows. one column has text value success or failure. I want to display the total success percentage(for the 5 tables) using PieChart. For that, i wanted to have a table with a single column having 50 rows
Hi t-taaror ,
If the schema and columns name are same then you can use Append Queries to get all data in single table.
Goto Edit Queries ==> Click on "Append Queries" ==> Select "Three or more tables"
Select the tables which needs to be append. Then click OK. You can create a new table then check the data if that is what you needed.
If this solves your problem mark this as solution and give khudos.
Thanks
