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 values for current hour.

I've tried to create a measure  CurrentHour = HOUR(NOW(), a calculated column isCurentHour = IF([DataHour] = [CurrentHour]; 1; 0) and filter isCurrentHour = 1, but when I publish report I realized that I need to refresh a whole dataset, to make filter work. Measure works fine, but not filter. I also have tried to create a table Table = FILTER('Data;Data[DataHour] = HOUR(NOW())), but It was the same result, I needed to refresh dataset.

I could use scheduled refresh, but I have a free version, so I can't make it refresh 24 times for every hour. Also I don't like the idea of 24 unnecessary http requests, since data doesn't changes.

Is it something I can do to make it work?

Thanks

 

4 Replies

    • 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