Dynamic Date & Time/ Dynamic Digital Watch in Power BI

 

Dynamic Date & Time / Dynamic Digital Watch in Power BI

(with Power BI Report Live Example)

First Time online, I am presenting a Digital clock/ Time/Dynamic watch in power bI. we all know how to show refresh date-time, which is static and will change only when we refresh the data. but here I'm showing the Date and Time of India dynamically, without manually refreshing the data.

 To achieve this I have been created Two Measures for two outputs. and a drill-down                  player visual.

Date & Time = UTCNOW()+(5.5/24)

here I have been UTC time and added 5.5 Hours to get the Indian time zone.
we can use now() also but our power bi Services cloud server will be in a diffrent location, so we won"t get India date & time.

To overcome this, I have taken UTCNOW() and added 5:30 min to it.

Measure 2 is to show only time, not the date part.

Time = format(UTCNOW()+(5.5/24),"hh:mm:ss")

To get only time from time and date I used the format function with the desired style of output.

 And coming to DrillDown player It's a Text /Value repeater visual, By using its functionality I have been achieved the desired output, By setting a series of numbers column in the visual and selecting auto play, auto loop and delay timing is one second.

so the page gets refreshed every second and we will get the date and time dynamically as our regular digital clock.

This scenario is just to show the date and time dynamically as a digital clock, It may not be advisable to use it in complex data reports, anyhow we can use and implement this Dynamic Digital Clock as per requirement.