Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

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 slice...
Need Help
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
6 years ago

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's avatar
    Anonymous
    Not applicable
    6 years ago

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