Help filtering time range by time stamp

Anonymous — Mon, 16 Aug 2021 11:02:35 GMT

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.

Re: Help filtering time range by time stamp

Anonymous — Wed, 18 Aug 2021 00:51:42 GMT

Hi @Anonymous,

It sounds like you want to achieve a custom filter effect from your slicer. For your requirement, you need to use the unconnected table as source of the slicer, then you can write a measure expression to extract the current value and compare it with table records to filter records and apply it on 'visual level filter' to filter records.

Using the SELECTEDVALUE function in DAX - SQLBI

Applying a measure filter in Power BI - SQLBI

Regards,

Xiaoxin Sheng

topic Help filtering time range by time stamp in Developer

Help filtering time range by time stamp

Re: Help filtering time range by time stamp