Forum Discussion
Post PatronSlicer on DateTime field
hi jitpbi - You can try the below approach
1. I extracted the minutes from the Date time field
Mins = MINUTE('Z-DateTime-Sort'[DateTime])2. Created a Hour-Mins columnHour-Mins = 'Z-DateTime-Sort'[Hour] + DIVIDE('Z-DateTime-Sort'[Mins], 60)3. Use the Hour-Mins column in the slicer - it would display time as "hh:mm" but more in the format displayed below
Please mark the post as a solution and provide a 👍 if my comment helped with solving your issue. Thanks!
Post PatronHi Anonymous ,
I tried by extracting "Hour" from the datetime field and used as another slicer but still some issue when need to filter something like in between (13:30 to 14:30) and also don't want to use 3 different filters for date, hour and minutes.
Is there any way if minutes can also come along with hours and then use "HourMinute" column as a slicer of type Between?
hi jitpbi - You can try the below approach
1. I extracted the minutes from the Date time field
3. Use the Hour-Mins column in the slicer - it would display time as "hh:mm" but more in the format displayed below
Please mark the post as a solution and provide a 👍 if my comment helped with solving your issue. Thanks!