Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
jitpbi
Post Patron
Post Patron

Slicer on DateTime field

Hi,

 

Is there any workaround possible to use both date and time when the type of slicer is Between?

Using visual/page level filter or filter at service is not preferable at all.

 

Thanks

1 ACCEPTED SOLUTION

hi @jitpbi - You can try  the below approach

 

1. I extracted the minutes from the Date time field 

Mins = MINUTE('Z-DateTime-Sort'[DateTime])
Date Time Slicer1.png
 
2. Created a Hour-Mins column
Hour-Mins = 'Z-DateTime-Sort'[Hour] + DIVIDE('Z-DateTime-Sort'[Mins], 60)
Date Time Slicer2.png 

 

3. Use the Hour-Mins column in the slicer - it would display time as "hh:mm" but more in the format displayed below

Date Time Slicer3.png

Please mark the post as a solution and provide a 👍 if my comment helped with solving your issue. Thanks!

 

Did I answer your question? Mark my post as a solution! Appreciate your Kudos!

Proud to be a Super User!



View solution in original post

5 REPLIES 5
Sumanth_23
Memorable Member
Memorable Member

hi @jitpbi - I am not too clear on the request - can you provide a screenshot on what your data looks like and what is the expected output? thanks! 

Did I answer your question? Mark my post as a solution! Appreciate your Kudos!

Proud to be a Super User!



Hi @Sumanth_23 ,

 

Please refer the below screnshot where first 2 slicers are "Dropdown" and "List" type while the third one is type of "Between" 

 

jitpbi_0-1600850186705.png

the same field (Datetime) is used for all three slicers above but time doesn't come in the third slicer. I want the time should also there along with the date in third type of slicer. 

 

Thanks

 

 

hi @jitpbi - The between slicer is not enabled to work with times - if you are using date time in slicers then you can only use the list and dropdown option. You can refer to the below link for a similar question: 

https://community.powerbi.com/t5/Desktop/Slicer-Date-and-Time/td-p/120431/page/2

 

The between slicer gives the user an option to use a date picker and hence designed to work with just dates even though you are adding a datetime column to the slicer. 

Sumanth_23_0-1600851640229.png

 

Unfortunately the only option with regard to Time is the "Relative Time" option; but not sure if that will serve your requirement

 

Sumanth_23_1-1600851723952.png

Please mark the post as a solution and provide a 👍 if my comment helped with solving your issue. Thanks!

 

Did I answer your question? Mark my post as a solution! Appreciate your Kudos!

Proud to be a Super User!



Hi @Sumanth_23 ,

 

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.

 

jitpbi_0-1600852555601.png

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 

Mins = MINUTE('Z-DateTime-Sort'[DateTime])
Date Time Slicer1.png
 
2. Created a Hour-Mins column
Hour-Mins = 'Z-DateTime-Sort'[Hour] + DIVIDE('Z-DateTime-Sort'[Mins], 60)
Date Time Slicer2.png 

 

3. Use the Hour-Mins column in the slicer - it would display time as "hh:mm" but more in the format displayed below

Date Time Slicer3.png

Please mark the post as a solution and provide a 👍 if my comment helped with solving your issue. Thanks!

 

Did I answer your question? Mark my post as a solution! Appreciate your Kudos!

Proud to be a Super User!



Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.