Forum Discussion
Connecting 3 different columns with different data
Hello
I am trying to connect 3 different tables so that i can view data in a single bargraph.
I am trying to have the maintenance graph for yearly data. All the 3 tables have different dates, different status. There is no common link between them. I tried to visualise them in a single barhraph and this is the endresult.
For plumbing its shows correct yearly data (break down for 3 years) and others its simply repeating the cumulative count of 3 years insteadd of yearly data (i believe its because i took date from Plumbing which is not related to Mechnaical and Electrical).
I tried to create link between the due dates and it didn't work.
I have uploaded the file here https://www.dropbox.com/s/4hbo3viq2sleij2/Maintenance.pbix?dl=0
Thanks in advance
Bishnu
Looking at the structure of the table, I would suggest you append the tables.
https://radacad.com/append-vs-merge-in-power-bi-and-power-query
Another way is to create common dimensions for the date, Type and Review Status and join them with these tables. And then analyze the data
2 Replies
- amitchandakSuper User
Looking at the structure of the table, I would suggest you append the tables.
https://radacad.com/append-vs-merge-in-power-bi-and-power-query
Another way is to create common dimensions for the date, Type and Review Status and join them with these tables. And then analyze the data
- bishnuHelper II
Hi amitchandak it worked. Thanks a lot