Creating visuals and slicers that utilize multiple tables with no relationship

[Anonymous]

I can't seem to find a way to accomplish this task.

I have an excel workbook that contains sensor measurement data. Every week the sensors collect measurments, and we pull those measurements into an excel worksheet that is denoted with the date on which we pulled the data. For example, the first worksheet is named "2020-10-19", then "2020-10-26, then "2020-11-02" and so on. Worksheet "2020-10-19" will have the measurments collected from 2020-10-12 to 2020-10-19.  The table itself only has the fields, sensorID, sensorState, and Measurment. It should be noted that "2020-10-19" may have 12 sensors, "2020-10-26" may have 33 sensors, and "2020-11-02" may have 25 sensors, majority of the sensors will be the same, but new ones can be added or older sensors did not collect anything for that week. 

Given this I want to be able to create a line graph that shows the changes in the measurments from the various sensors that we have from worksheet to worksheet, with each point on the x-axis being the date we pulled the data. To top it off I also need to add a slicer that lets me select between a date range. for example if I want to see the measurment changes from "2020-09-14" to "2020-10-19". 

Any help would be greatly apprciated, I do not expect a straight forward answer, but any ideas would be helpful. 

Thank you in advance. 🙂

Also if extra information is needed I will try to mock up something as the underlying data is sensitive. 

[Anonymous]

Here is a link to the test data set in my google drive.

https://drive.google.com/file/d/1YlvkxqVe3f6G7OfePVZqrLP6G_224QsK/view?usp=sharing

[TomMartens · Accepted solution]

Hey @Anonymous ,

please provide sample data, meaning a workbook, that contains more than 2 sheets. Upload the the workbook the onedrive or dropbox and share the link.

I recommend to stitch the data from the each sheet on top of each other (append opeartion in Power Query) using the sheetname as an additional column.

Regards,

Tom

[Anonymous]

This ended up working for me, sorry for the late response. 

Thank you!