Forum Discussion
Show current hour values
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
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.