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 an...
Comments
Post a Comment