Connecting 3 different columns with different data

[bishnu]

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

[amitchandak · Accepted solution]

@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

[bishnu]

Hi @amitchandak  it worked. Thanks a lot