Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
mussaenda
Super User
Super User

Shift Slicer

‎09-24-2019 01:01 AM

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 are

1. Scan Start Date Time dd/mm/yyyy hh:mm:ss

2. Scan End Date Time dd/mm/yyyy hh:mm:ss

 

Can Anyone give insights or solutions to this? It will be highly appreciated.

Thank you

Labels:
Message 1 of 5
917 Views
0
4 REPLIES 4
v-diye-msft
Community Support
Community Support

‎09-24-2019 07:06 PM

Hi @mussaenda 

 

I don't understand what you're looking for. Do you mean you need the morning shift slicer and Night Shift slicer?

 

please kindly read this post to get your question answered more quickly:

https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

 

Community Support Team _ Dina Ye
If this post helps, then please consider Accept it as the solution to help the other members find it more
quickly.
Message 2 of 5
884 Views
0
mussaenda
Super User
Super User
In response to v-diye-msft

‎09-24-2019 09:32 PM

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

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

Message 3 of 5
868 Views
0
v-diye-msft
Community Support
Community Support
In response to mussaenda

‎09-25-2019 01:07 AM

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?

 

Community Support Team _ Dina Ye
If this post helps, then please consider Accept it as the solution to help the other members find it more
quickly.
Message 4 of 5
853 Views
0
mussaenda
Super User
Super User
In response to v-diye-msft

‎10-07-2019 05:42 AM

 

    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

 

 

 

Message 5 of 5
844 Views
0

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

December 2025 Power BI Update Carousel

Power BI Monthly Update - December 2025

Check out the December 2025 Power BI Holiday Recap!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

View All