Forum Discussion

mussaenda's avatar
mussaenda
Community Champion
6 years ago

Shift Slicer

I have read some threads but it did not solve my problem.   We have 2 shifts in manufacturing. Morning Shift : 6am - 6pm same day Night Shift : 6pm today - 6am next day   What I have in my Data...
Need Help
mussaenda's avatar
mussaenda
Community Champion
6 years ago

Sorry I didn't notice that I did not disclose what I need.

Yes, Slicer for 2 shifts is What I am lookin for.

  • v-diye-msft's avatar
    v-diye-msft
    Community Support
    6 years ago

    Ok, would you mind sharing your simple worksheet or preferable dummy pbix?

    Also, please let me know how would you like to set the logic? For example, if the manufacturing time starts at 10:00 a.m to 22:00 p.m, which shift should belong to?

     

    • mussaenda's avatar
      mussaenda
      Community Champion
      6 years ago

       

          ID	          DateTime_Start	    DateTime_End
ABDI-02636912	07/10/2019 14:54	07/10/2019 14:55
ABDI-01537012	07/10/2019 14:53	     
ABDI-01318112	07/10/2019 11:47	07/10/2019 14:30
ABDI-01537012	07/10/2019 11:46	07/10/2019 14:52
ABDI-01874012	07/10/2019 10:47	07/10/2019 12:40
ABDI-06454412	07/10/2019 09:37	     
ABDI-01537012	07/10/2019 09:31	07/10/2019 11:27
ABDI-01874012	07/10/2019 09:08	07/10/2019 10:39
ABDI-01318112	07/10/2019 08:38	07/10/2019 10:51
ABDI-06454112	07/10/2019 08:14	07/10/2019 09:57
ABDI-02636912	07/10/2019 08:02	07/10/2019 11:21
ABDI-02625412	07/10/2019 07:34	07/10/2019 11:27
ABDI-01874012	07/10/2019 06:25	07/10/2019 08:47
ABDI-02635312	07/10/2019 06:14	07/10/2019 09:06
ABDI-02636912	07/10/2019 06:11	07/10/2019 07:37
ABDI-02625412	07/10/2019 06:10	07/10/2019 07:03
ABDI-01316712	07/10/2019 05:01	     
ABDI-02623112	07/10/2019 04:36	     
ABDI-01534812	07/10/2019 04:32	07/10/2019 05:58
ABDI-01534612	07/10/2019 04:32	07/10/2019 05:59
ABDI-01878412	07/10/2019 04:25	07/10/2019 05:55
ABDI-01316712	07/10/2019 03:36	07/10/2019 05:01
ABDI-01534812	07/10/2019 03:15	07/10/2019 04:32
ABDI-01534612	07/10/2019 03:08	07/10/2019 04:31
ABDI-02623412	07/10/2019 02:03	     
ABDI-01316712	07/10/2019 01:59	07/10/2019 03:36
ABDI-01534812	07/10/2019 01:43	07/10/2019 03:15
ABDI-01534612	07/10/2019 01:35	07/10/2019 03:07
ABDI-01878412	07/10/2019 01:22	07/10/2019 03:11
ABDI-02623412	06/10/2019 23:19	07/10/2019 01:57
ABDI-01316712	06/10/2019 23:08	07/10/2019 01:59
ABDI-01534812	06/10/2019 22:45	07/10/2019 01:32
ABDI-01534612	06/10/2019 22:32	07/10/2019 01:35
ABDI-01316712	06/10/2019 21:44	06/10/2019 23:08
ABDI-02623412	06/10/2019 21:24	07/10/2019 01:57
ABDI-01534812	06/10/2019 21:23	06/10/2019 22:45
ABDI-06454012	06/10/2019 21:21	06/10/2019 23:13
ABDI-02623112	06/10/2019 21:04	06/10/2019 23:31
ABDI-01534612	06/10/2019 20:42	06/10/2019 22:31
ABDI-02625512	06/10/2019 20:37	06/10/2019 23:12
ABDI-02623412	06/10/2019 20:03	06/10/2019 21:17
ABDI-01534812	06/10/2019 19:57	06/10/2019 21:02
ABDI-01316712	06/10/2019 19:56	06/10/2019 21:20
ABDI-01878412	06/10/2019 19:42	06/10/2019 21:36
ABDI-01534612	06/10/2019 19:09	06/10/2019 20:42
ABDI-02623412	06/10/2019 18:22	06/10/2019 20:03
ABDI-01534812	06/10/2019 18:13	06/10/2019 19:39
ABDI-02623112	06/10/2019 18:12	06/10/2019 20:43
ABDI-01316712	06/10/2019 18:07	06/10/2019 19:56
ABDI-01537012	06/10/2019 15:30	06/10/2019 17:44
ABDI-01874012	06/10/2019 15:25	06/10/2019 17:36
ABDI-TEMP0412	06/10/2019 14:31	     
ABDI-02636912	06/10/2019 14:30	06/10/2019 16:45
ABDI-02635312	06/10/2019 14:17	06/10/2019 16:05
ABDI-02636912	06/10/2019 14:06	06/10/2019 14:07
ABDI-02625412	06/10/2019 13:59	06/10/2019 17:20
ABDI-01537012	06/10/2019 13:22	06/10/2019 15:16
ABDI-01874012	06/10/2019 12:24	06/10/2019 15:09
ABDI-06454112	06/10/2019 11:36	06/10/2019 11:38
ABDI-02636912	06/10/2019 11:09	06/10/2019 12:57
ABDI-01874012	06/10/2019 10:47	06/10/2019 12:11
ABDI-01537012	06/10/2019 10:31	06/10/2019 12:00
ABDI-02635312	06/10/2019 10:23	06/10/2019 12:07
ABDI-01874012	06/10/2019 09:02	06/10/2019 10:30
ABDI-02625412	06/10/2019 08:53	06/10/2019 13:17
ABDI-02636912	06/10/2019 08:47	06/10/2019 10:49
ABDI-01537012	06/10/2019 08:29	06/10/2019 10:18
ABDI-01318112	06/10/2019 08:26	06/10/2019 09:59
ABDI-02635312	06/10/2019 08:21	06/10/2019 10:15
ABDI-06454112	06/10/2019 06:57	06/10/2019 11:07
ABDI-01318112	06/10/2019 06:32	06/10/2019 08:11
ABDI-01874012	06/10/2019 06:30	06/10/2019 08:38
ABDI-06454412	06/10/2019 06:29	06/10/2019 09:34
ABDI-02636912	06/10/2019 06:07	06/10/2019 08:27
ABDI-02635312	06/10/2019 06:01	06/10/2019 07:55
ABDI-01537012	06/10/2019 05:59	06/10/2019 08:15
ABDI-01871512	05/10/2019 09:42	     
ABDI-01874012	04/10/2019 04:12	04/10/2019 06:00
ABDI-02625412	04/10/2019 03:04	04/10/2019 04:39
ABDI-01537012	04/10/2019 02:36	04/10/2019 04:04

      Hello,

       

       

      Here is my sample data.

      Morning Shift: 6am-6pm (Same Day)

      Night Shift: 6pm-6am (next day)

       

      For now, I am basing on Datetime Start.

      and I am using the Datetime End for the duration.

      I am ahving a hard time with the slicer.

       

      Needed Output:

      Morning Shift of Oct6 (6am-6pm)

      All ID that started from the said shift

       

      ABDI-01537012	06/10/2019 15:30	06/10/2019 17:44
ABDI-01874012	06/10/2019 15:25	06/10/2019 17:36
ABDI-TEMP0412	06/10/2019 14:31	     
ABDI-02636912	06/10/2019 14:30	06/10/2019 16:45
ABDI-02635312	06/10/2019 14:17	06/10/2019 16:05
ABDI-02636912	06/10/2019 14:06	06/10/2019 14:07
ABDI-02625412	06/10/2019 13:59	06/10/2019 17:20
ABDI-01537012	06/10/2019 13:22	06/10/2019 15:16
ABDI-01874012	06/10/2019 12:24	06/10/2019 15:09
ABDI-06454112	06/10/2019 11:36	06/10/2019 11:38
ABDI-02636912	06/10/2019 11:09	06/10/2019 12:57
ABDI-01874012	06/10/2019 10:47	06/10/2019 12:11
ABDI-01537012	06/10/2019 10:31	06/10/2019 12:00
ABDI-02635312	06/10/2019 10:23	06/10/2019 12:07
ABDI-01874012	06/10/2019 09:02	06/10/2019 10:30
ABDI-02625412	06/10/2019 08:53	06/10/2019 13:17
ABDI-02636912	06/10/2019 08:47	06/10/2019 10:49
ABDI-01537012	06/10/2019 08:29	06/10/2019 10:18
ABDI-01318112	06/10/2019 08:26	06/10/2019 09:59
ABDI-02635312	06/10/2019 08:21	06/10/2019 10:15
ABDI-06454112	06/10/2019 06:57	06/10/2019 11:07
ABDI-01318112	06/10/2019 06:32	06/10/2019 08:11
ABDI-01874012	06/10/2019 06:30	06/10/2019 08:38
ABDI-06454412	06/10/2019 06:29	06/10/2019 09:34
ABDI-02636912	06/10/2019 06:07	06/10/2019 08:27
ABDI-02635312	06/10/2019 06:01	06/10/2019 07:55
ABDI-01537012	06/10/2019 05:59	06/10/2019 08:15

       

      Night Shift of Oct6 (6pm-6am) next day

      All ID that started from the said shift

       

      ABDI-01316712	07/10/2019 05:01	     
ABDI-02623112	07/10/2019 04:36	     
ABDI-01534812	07/10/2019 04:32	07/10/2019 05:58
ABDI-01534612	07/10/2019 04:32	07/10/2019 05:59
ABDI-01878412	07/10/2019 04:25	07/10/2019 05:55
ABDI-01316712	07/10/2019 03:36	07/10/2019 05:01
ABDI-01534812	07/10/2019 03:15	07/10/2019 04:32
ABDI-01534612	07/10/2019 03:08	07/10/2019 04:31
ABDI-02623412	07/10/2019 02:03	     
ABDI-01316712	07/10/2019 01:59	07/10/2019 03:36
ABDI-01534812	07/10/2019 01:43	07/10/2019 03:15
ABDI-01534612	07/10/2019 01:35	07/10/2019 03:07
ABDI-01878412	07/10/2019 01:22	07/10/2019 03:11
ABDI-02623412	06/10/2019 23:19	07/10/2019 01:57
ABDI-01316712	06/10/2019 23:08	07/10/2019 01:59
ABDI-01534812	06/10/2019 22:45	07/10/2019 01:32
ABDI-01534612	06/10/2019 22:32	07/10/2019 01:35
ABDI-01316712	06/10/2019 21:44	06/10/2019 23:08
ABDI-02623412	06/10/2019 21:24	07/10/2019 01:57
ABDI-01534812	06/10/2019 21:23	06/10/2019 22:45
ABDI-06454012	06/10/2019 21:21	06/10/2019 23:13
ABDI-02623112	06/10/2019 21:04	06/10/2019 23:31
ABDI-01534612	06/10/2019 20:42	06/10/2019 22:31
ABDI-02625512	06/10/2019 20:37	06/10/2019 23:12
ABDI-02623412	06/10/2019 20:03	06/10/2019 21:17
ABDI-01534812	06/10/2019 19:57	06/10/2019 21:02
ABDI-01316712	06/10/2019 19:56	06/10/2019 21:20
ABDI-01878412	06/10/2019 19:42	06/10/2019 21:36
ABDI-01534612	06/10/2019 19:09	06/10/2019 20:42
ABDI-02623412	06/10/2019 18:22	06/10/2019 20:03
ABDI-01534812	06/10/2019 18:13	06/10/2019 19:39
ABDI-02623112	06/10/2019 18:12	06/10/2019 20:43
ABDI-01316712	06/10/2019 18:07	06/10/2019 19:56

      I searched and read posts here but I did not achieve this output.

      Thank you