Create a filter between two specifict hours

[Anonymous]

Hi!

I am trying to create a filter or a slicer for one of my columns that have an specific time , I just want the date for the column Time_in between 6:30 am and 5:00 pm, but when I create the slicer it read as a date instead of a time

[teju_11]

Hi.. I am also looking for the workaround to add the time filter b/w those hours. Did you resolve that ?

[Anonymous]

Hi @Anonymous 

Could you tell me if your problem has been solved? If it is, kindly Accept the helpful reply as the solution. More people will benefit from it. Or you are still confused about it, please provide me with more details about your problem or share me with your pbix file from your Onedrive for Business.

Best Regards,

Rico Zhou

[amitchandak]

@Anonymous , You can create a time table and try

https://kohera.be/blog/power-bi/how-to-create-a-time-table-in-power-bi-in-a-few-simple-steps/

Split date into date and time

Time = [datetime].time

You have check does you get between option in slicer with time.

[amitchandak]

@Anonymous , You can create a time table and try

https://kohera.be/blog/power-bi/how-to-create-a-time-table-in-power-bi-in-a-few-simple-steps/

Split date into date and time

Time = [datetime].time

You have check does you get between option in slicer with time.

[Anonymous]

Hi @Anonymous

Please check the below video

https://www.youtube.com/watch?v=hspRabT_JkU

[Greg_Deckler]

@Anonymous - Correct, it is a relative date slicer, not a relative time slicer. You get the 1899 date because Power BI's (DAX's) time starts on I believe midnight December 30th, 1899.

[Anonymous]

Thanks for your answer, do you know how can I just filter between those hours?