Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

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.

Reply
SquanchTheGod
Frequent Visitor

Creating visuals and slicers that utilize multiple tables with no relationship

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. 

1 ACCEPTED SOLUTION
TomMartens
Super User
Super User

Hey @SquanchTheGod ,

 

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

 



Did I answer your question? Mark my post as a solution, this will help others!

Proud to be a Super User!
I accept Kudos 😉
Hamburg, Germany

View solution in original post

3 REPLIES 3
SquanchTheGod
Frequent Visitor

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
Super User
Super User

Hey @SquanchTheGod ,

 

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

 



Did I answer your question? Mark my post as a solution, this will help others!

Proud to be a Super User!
I accept Kudos 😉
Hamburg, Germany

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

 

Thank you!

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.