Dynamic Countdown Timer in Power BI

[smjzahid]

Hi

I have a Date table (see second snip below) with below shown columns. I have a requirment to show COUNTDOWN TIMER (A dynamic clock) ticking continously showing the time left for below shown reporting dates. (Consider this to be a typical Countdown Timer shown before OLYMPIC GAMES showing How many days left before the event begins in (DD/MM/YY HH:MM:SS) format.

How do I insert dynamic countdown timer next to (week 1,2 and 3) please

Here is my data table shown below. The question is how do I make this show dynamic.

Please note, this needs to dynamic once this report has been published to PBI Service (which works in UTC time) and I am based in the UK, so my laptop timing is GMT.

How do we achieve this, any help is highly appreciated

[renaudstaessens]

@smjzahid : I have a very similar requirement.  i have a table with items and expected hour of resolution for this items ( day hours and minutes domething like dd/hh/mm) . for each item i d like to calculate the remainign time between now and expected hour. Of course i'd like the report to refresh frequently so that i can see changes in the remaining time . Did you solve the issue ? could you guide/help

ID	Expected hour of resolution	Time Remaining
1	10:25:30	02:05:30 (2hours 5 min 30 sec left )
2	10:35:00	02:10:00 ( 2 hours 10 min left)

Regards

[v-yingjl]

Hi @smjzahid ,

As far as I know, the countdown timer visual based on the date which entered manually and your local PC time to calculate the diff, not on the date table.

If you want to get the simliar diff from the date table, you can try to create measure like this but it could not be always dynamic.

First Diff = 
VAR _startdate =
    DATE ( 2022, 2, 4 )
VAR _date =
    MINX (
        FILTER ( 'Table', WEEKDAY ( 'Table'[Date], 2 ) = 3 && 'Table'[Week_Number] = 1 ),
        [Date]
    )
VAR _dd =
    DATEDIFF ( _date, _startdate, DAY )
VAR _hh =
    MOD ( DATEDIFF ( _date, _startdate, HOUR ), 24 )
VAR _mm =
    MOD ( DATEDIFF ( _date, _startdate, MINUTE ), 24 * 60 )
VAR _ss =
    MOD ( DATEDIFF ( _date, _startdate, SECOND ), 24 * 60 * 60 )
RETURN
    _dd & ":" & _hh & ":" & _mm & ":" & _ss

Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Syndicate_Admin]

I'm trying to do something similar, but instead of using a variable for the week(s) I need a (non-manual) countdown timer based on communications we're sending to contractors and a specific due date for them to respond. The filter would be either the communication name or the communication #. I'm using the countdown timer visual right now & would like for this to be dynamic. I attached a sample table. 

[edhans]

Consider using a visual designed for this @smjzahid - here is one. Count Down Timer (microsoft.com)

The only way I can think of to do this without a custom visual is to have a direct query getting time from a SQL or other relational database, then set the page refresh as low as you can, but it requires Premium to go down to 5 second intervals, including Premium Per User. Pro I think is locked to 30 seconds or higher.

[edhans]

@smjzahid can you respond and let us know if one of these is the solution you needed, or post back with additional questions? Thanks.