Forum Discussion

smjzahid's avatar
smjzahid
Helper V
5 years ago

Dynamic Countdown Timer in Power BI

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 repor...
Need Help
Show and Tell
v-yingjl's avatar
v-yingjl
Community Support
5 years ago

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's avatar
    Syndicate_Admin
    Administrator
    2 years ago

    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.