Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to Solution.
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
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
99 | |
82 | |
70 | |
63 |
User | Count |
---|---|
145 | |
111 | |
104 | |
84 | |
64 |