Live Clock requires calling the DAX repeatedly

[darkinvader_]

Hi

So as we already know a measure runs when it is called, I was wondering can we somehow call it continously. I'm building this Clock visual with the help of HTML Content visual and this is how it looks

I've used animate tag to second hand which helps it keep moving in sweep movement, issue is that if I need to move Hour and Minute hand I need the Now() function to called continuously so that I can keep the clock up to date. Has anyone worked on it by any chance?

I know calling a Measure continuously can have a impact on the performance but this is just for fun

BR
Dark

[mark_endicott]

@darkinvader_ - Just create a direct query connection to an empty file stored in sharepoint, or a SQL table that has no rows (many other options available). 

As long as you don't put anything from that table on the page, the option will be enabled and you'll never have any queries sent to your source. It's a wild west workaround, but it'll work. 

[mark_endicott]

@darkinvader_ - You access it when you have nothing selected on the canvas, and choose the format option:

[darkinvader_]

@mark_endicott  this what I've on page

edited:
found the reason why I don't have that

anyways will accept it as a solution but will love to have a refresh visual functionality in furture something similar to Optimize tab

[darkinvader_]

Hi @mark_endicott 

looks like a solution to me but the Refresh Page option is not visible on my end maybe I've to switch on some toggle or enable some feature let me find it out and once your solution works. Will defitniely give you a thumbs up

BR
Dark 

[mark_endicott · Accepted solution]

@darkinvader_ - If you really must do this, you can set the page to automatically refresh every 1 second:

If his works, please accept as the solution, it helps with visibilty for others with the same challenge.