Forum Discussion
Getting data from 2 different tables into single chart.
Hi,
Here is my requirement, I need some suggestions on how i can get this done.
I have 2 different table containing test executions data from 2 different tools. Although i can get 2 different graphs for each of these tables, but i want to get data reported in single graph in Power BI.
For eg : I want get No. test executed reported in a single graph getting data from 2 tables.
Any suggestions how can i get this done?
Hi,
Here is what i did. Matched up columns of these 2 tables & used append as new to combine data into another table. This seem to work for me.
thanks for your suggestion.
3 Replies
arvindsj , You can create common tables like for Date or any other dimensions and use that to display data together :
Bridge Table : https://www.youtube.com/watch?v=Bkf35Roman8
https://www.sqlbi.com/articles/the-importance-of-star-schemas-in-power-bi/
To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s. Refer :radacad sqlbi My Video Series Appreciate your Kudos.
Hi arvindsj ,
Do two tables have the same structure？If so, you can try to append these two tables in one table:
Please refer to https://radacad.com/append-vs-merge-in-power-bi-and-power-query Or you can use bridge table and dax to show value from two table. It all depends on what you need to show on visual.
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Best Regards,
Dedmon Dai
Hi,
Here is what i did. Matched up columns of these 2 tables & used append as new to combine data into another table. This seem to work for me.
thanks for your suggestion.
