Forum Discussion
Multi tables
So I am managing a big area of forest with multiple divisions and what i want to do is creat an interactive dashboard.
The problem is i have in each excel sheet one operation and one year in a total of 30 excel sheets and i wanto to connect them all to see the data with the filters (operation, year, division). Thanks in advance if needed i can post where the tables.
2 Replies
The first step would be to append if they are in the same format
https://radacad.com/append-vs-merge-in-power-bi-and-power-query
Also, refer:
https://docs.microsoft.com/en-us/power-bi/desktop-shape-and-combine-data
you might consider creating pbix file that will contain some sample data (remove the confidential info), upload the pbix to onedrive or dropbox and share the link to the file. Please do not forget to describe the expected results based on this sample data.
