Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Filter with a TIME SLICER

I am looking how to use a slicer to filter between different times in my report. For instance, Say i want to filter between 10:30am and 11:30am using a slicer instead of the relative time filter. 
NOTE: I am currently able to filter by hours after converting my time column to HOURS. so i am able to filter say from 0-23 hrs. But i want to be able to filter by hour and minutes. 

Need Help

2 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    3 years ago

    Anonymous , seem like power bi do not take between for time,

    Create two independent table with all hours/time and use them to control the meausre

     

    Time Range Using 2 slicer =
    var _max = minx(allselected(Time1), Time1[Time])
    var _min = maxx(allselected(Time2), Time2[Time])
    return
    calculate(countrows(Table), Filter(Table,Table[Time] <=_max && Table[Time] >=_min) )

     

     

    I think very similar approach here

    Select data between months - https://youtu.be/nEt7dT3Tfv4

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    thanks let me try this out.