Forum Discussion

hkillen's avatar
hkillen
Helper I
4 years ago
Solved

'Time' Slicer

I need a slicer that, when an a Time value value is selected, outputs all records with a with a time stamp equal to or greater than the time value selected.  For example, if the 12:00 PM value is selected, not only records with 12:00 are output, but any records with a time stamp > 12:00 is output.  Any ideas?

Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi hkillen ,

    I have created a simple sample, please refer to it to see if it helps you.

    Create a time table base on the table.

    Table 2 = SUMMARIZE('Table','Table'[time])

    Put the field into the slicer.

    Then create a measure.

    Measure = var _1=SELECTEDVALUE('Table 2'[time])
return
IF(MAX('Table'[time])>=_1,1,0)

    Then filter the measure.

    If I have misundrstood you meaning, please provide more details with your desired output and pbix file without privacy information.

     

    Best Regards
    Community Support Team _ Polly

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

     

2 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    4 years ago

    hkillen , Create a time table, Do not join with your table

     

    Make sure you have time column in you table

     

    Time1 = timevalue([datetime])

     

    then you can create a measure like

    calculate(Sum(Table[Value]), Filter(Table, Table[Time1] >= selectedvalue(Time[Time]) ) )

     

    Power Query- List.Times- Create Time Table: https://youtu.be/-pxMpTdnTVc

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi hkillen ,

    I have created a simple sample, please refer to it to see if it helps you.

    Create a time table base on the table.

    Table 2 = SUMMARIZE('Table','Table'[time])

    Put the field into the slicer.

    Then create a measure.

    Measure = var _1=SELECTEDVALUE('Table 2'[time])
return
IF(MAX('Table'[time])>=_1,1,0)

    Then filter the measure.

    If I have misundrstood you meaning, please provide more details with your desired output and pbix file without privacy information.

     

    Best Regards
    Community Support Team _ Polly

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.