Forum Discussion

tboonhau's avatar
tboonhau
Frequent Visitor
3 years ago

Filter Visual Last 24 hours

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

 

 

Need Help

2 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    3 years ago

    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's avatar
      tboonhau
      Frequent Visitor
      3 years ago

      Hi there, 

       

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