Forum Discussion

toyota_carina's avatar
toyota_carina
Regular Visitor
8 years ago

Show current hour values

Hi. I'm getting some data using http request. Data contains values for every hour for current day.  I want to refresh dataset just once a day to get all values, and every hour exact at 00 show valu...
toyota_carina's avatar
toyota_carina
Regular Visitor
8 years ago

So there is no way to make filter works dynamically? Measure refreshes when I refresh webpage, but I don't understand why FILTER('Data;Data[DataHour] = HOUR(NOW())) function doesn't work the same way, why I do need to refresh the whole dataset for that.. 

  • v-huizhn-msft's avatar
    v-huizhn-msft
    Microsoft Employee
    8 years ago

    Hi toyota_carina,

    As I tested, I create two measure in my .pbix file.

    Current_Time = NOW()
Hour of Current_time = HOUR(NOW())


    I create two card visuals to display the measure. At first, it shows the following result.



    After a while 10 o'clock, the measure didn't refresh automatically untill I click "refresh" buttom on the home page. It shows the latest time as follows.



    Best Regards,
    Angelia

    • toyota_carina's avatar
      toyota_carina
      Regular Visitor
      8 years ago

      Hi, v-huizhn-msft.

       

      I know that measure value rerfreshes when "refesh" button is clicked or page is refreshed (F5). But if you will try to use measure to filter not DirectQuery dataset, page refresh will not help. You must refresh a whole dataset for that.
      And it is wrong, it should be dynamic.
      I've created a sample file on google drive CurrentHourTest.pbix for show what I mean.

      I've created a table with hours and value columns. My goal is that this table filters when current hour changes. F.ex. if it's 2p.m. it dynamicly filters row where hour = 14, without refreshing whole dataset, because I already do have a data for every hour for current day. In example pbix I used 2 ways for accomplish that: 1.  create a new tabel using FILTER() function  and 2. create a new calculated column and filter by it.

      But when I published this report, meause shows correct value and changes by refreshing page, but none of filters shows correct values next hours, until you refresh dataset.

      Screenshot