Fixed Time Buttons for Table

Hi Anonymous,

May be you can try use the slicer like the following :

If this ok, create a measure as a dynamic tag and let it in filters pane.

Measure = 
var _2hours = NOW()-TIME(2,0,0)
var _12hours = NOW()-TIME(12,0,0)
var _24hours = NOW()-TIME(23,59,59)
var _weekhours = NOW()-TIME(23,59,59)*7
var _month = NOW()-TIME(23,59,59)*30
return
SWITCH(TRUE(),
SELECTEDVALUE(Button[button])="2 hours",_2hours,
SELECTEDVALUE(Button[button])="12 hours",_12hours,
SELECTEDVALUE(Button[button])="24 hours",_24hours,
SELECTEDVALUE(Button[button])="week",_weekhours,
SELECTEDVALUE(Button[button])="month",_month,TIME(0,0,0))

Measure 2 = IF(SELECTEDVALUE('Table'[DateTime])>=[Measure],1,BLANK())

If you want use button, bookmarks and slicer are used in combination. Bookmarks are linked to the specified slicer.

Pbix in the end you can refer.

Best Regards

Community Support Team _ chenwu zhu

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