Display data between 2 dates (not exclusive) for Gantt Chart

[Anonymous]

Hello community! I am running into a problem I can't seem to find the solution to, even after a lot of research and trials.

I have machine activity data. For example

MachineName	StartDate	EndDate	Status
A	2021-06-08 10:00:05	2021-06-08 12:10:00	Active
A	2021-06-08 12:10:01	2021-06-08 1:32:12	Paused
B	2021-06-08 9:00:00	2021-06-08 9:23:02	Active

The goal is to display this info on a Gantt chart where we would see every machine and their status on a timeline (see example below).

My issue is with time intelligence. There will be a calendar filter on the page and I want, for example, if we filter on "From 2021-06-08 8:59:00 To 2021-06-08 11:00:00, that part of the activity of Machine A to show up and also Machine B's activity to be displayed.

Here is a sample of my data:

Sample Data 

Thanks in advance!

[v-jayw-msft]

Hi @Anonymous ,

You could create a measure use IF() function. If the Machine is active then measure =1 else measure =0. At last add this measure to visual filter.

Best Regards,

Jay