Time slicing visuals using a TimeTable

Hi HB_1110 ,

Here is my sample data:

There is no relationship between these two tables:

Use this DAX to create a measure:

Filter = 
VAR _minhour = MIN('TimeTable'[Hour])
VAR _maxhour = MAX('TimeTable'[Hour])
VAR _minminute = MIN('TimeTable'[Minute])
VAR _maxminute = MAX('TimeTable'[Minute])
VAR _mintime = TIME(_minhour,_minminute,0)
VAR _maxtime = TIME(_maxhour,_maxminute,0)
RETURN
IF(
    MAX('Table'[occurred_time]) <= _maxtime && MAX('Table'[occurred_time]) >= _mintime,
    1,
    0
)

Make the settings as shown in the following figure:

And the final output is as below:

Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.