Forum Discussion
Create a filter between two specifict hours
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
7 Replies
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 , 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 , 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.
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
Hi.. I am also looking for the workaround to add the time filter b/w those hours. Did you resolve that ?
