cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
sanjay009
Helper III
Helper III

Time range filter

I have a table as below

 

Groups12 AM1 AM2 AM3 AM4 AM5 AM6 AM7 AM
G-SUPPORT3222771801431019413477
A-SUPPORT10423464860573533
B-SUPPORT1419193838165310
F-SUPPORT349260232271136193178110

 

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

 

IDshift _descType
112 AM - 2 AM1 st
22 AM - 4 AM2nd
34  AM - 7 AM3rd

 

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?

1 ACCEPTED SOLUTION
CNENFRNL
Community Champion
Community Champion

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.

Screenshot 2020-11-01 062912.pngScreenshot 2020-11-01 062844.png

Then slicer works easily,

Screenshot 2020-11-01 063159.png

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

View solution in original post

1 REPLY 1
CNENFRNL
Community Champion
Community Champion

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.

Screenshot 2020-11-01 062912.pngScreenshot 2020-11-01 062844.png

Then slicer works easily,

Screenshot 2020-11-01 063159.png

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

View solution in original post

Helpful resources

Announcements
2022 Release Wave 1 760x460.png

2022 Release Wave 1 Plan

Power Platform release plan for the 2022 release wave 1 describes all new features releasing from April 2022 through September 2022.

Power BI December 2021 Update_carousel 768x460.jpg

Check it Out!

Click here to read more about the December 2021 Updates!

User Group Leader Meeting January 768x460.png

Calling all User Group Leaders!

Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.

Jan 2022 Dev Camp 768x460 copy.png

Power BI Dev Camp- January 27th, 2022

Mark your calendars and join us for our next Power BI Dev Camp!

Top Solution Authors
Top Kudoed Authors