Hello!
I am using an excel workbook as my source data here. Within the workbook there are individuel sheets for seperate bits of equipment with a number of variables recorded at minutel time stamps. The data is pulled to a master sheet that displays the time stamp and some other information whenever a limit is exceeded (i.e a trip) in one of the sheets, only a single time stamp is given for each trip.
In PowerBI, I am trying to create a line chart which will display a trend of the variables which apply to the trip, over a time period of 2 hours surrounding the trip.
For example: A trip occurs at 21/06/2021 08:00:00. I want to see all of the variables trended on the line chart for each of the minute time stamps between 21/06.2021 07:00:00 and 21/06.2021 09:00:00.
I have a table below the line chart which I'd like to use as the slicer. This table shows the trips from the master sheet. When I select the trip on that table, i would like the trend of the 2 hours surrounding that trip to be displayed on the line chart.
Currently, when I select the trip on the table, only the variables at that exact time stamp are displayed, because it is only reading the master trip table. How can I link that line chart back to the data that I require, so that when I select the trip on the displayed table, it looks for all of the time stamps for that trip in the required source table.
Any help would be greatly appreciated, and my appologies for any poor descriptions. I would include images but I'm restricted by my companies privacy policies.
