Filter Visual Last 24 hours

[tboonhau]

Need some help here, I applied a visual filter to get the last 24 hours but the time now is 11:24 AM but in the filter it is only 3:06AM.  I would like the filter to follow my clock, which means I want the visual to show from 17/1/2023 11:24AM - 18/1/2023 11:24AM. Thanks

[amitchandak]

@tboonhau , Create a measure like the below and use that in the visual or visual level filter and check for nonblank

countrows(filter(Table, Table[DateTime]> now() -1 && Table[DateTime]<= now() ) )

[tboonhau]

Hi there, 

Thanks but I created the measure you suggested. But it doesn't work in my chart. I got a blank chart instead