Time range filter

[sanjay009]

I have a table as below

Groups	12 AM	1 AM	2 AM	3 AM	4 AM	5 AM	6 AM	7 AM
G-SUPPORT	322	277	180	143	101	94	134	77
A-SUPPORT	104	23	46	48	60	57	35	33
B-SUPPORT	14	19	19	38	38	16	53	10
F-SUPPORT	349	260	232	271	136	193	178	110

we have three shifts from 12 - 2 , 2 -4 and 4- 7 AM, i created a shift table as below

ID	shift _desc	Type
1	12 AM - 2 AM	1 st
2	2 AM - 4 AM	2nd
3	4  AM - 7 AM	3rd

I want to create a filter for shift_desc. When i select 12 AM - 2AM check box i want above table to display in range 12 AM - 2 AM.How can i do this?

[CNENFRNL · Accepted solution]

Hi, @sanjay009 , in order to apply filter to a range of time, I convert the tables given that DAX functions in a column-wise manner.

Then slicer works easily,

You might want to refer to the attached file for more details.