'Time' Slicer

[hkillen]

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?

[v-rongtiep-msft · Accepted solution]

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.

[amitchandak]

@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