Countdown fields and settings

    Every field well and every setting in the format pane of version 1.0.1.0, read from the package you download. The internal names in grey are what a PBIR file or a report-authoring agent uses. Which features need a licence is on the Countdown page; every setting works in edit mode with or without one.

    9 fields · 15 cards · 107 settings Markdown for AI assistantscatalog.json

    Fields

    FieldTakesNeededWhat it is for
    DeadlinetargetColumn or measureOptionalThe date to count down to. Leave empty and set a date in the format pane instead.
    Event dateseventsColumnOptionalDates of the events to count up FROM - incidents, resets, releases. Bind the whole column and the visual also reports the best streak on record.
    StartstartColumn or measureOptionalStart of the window, for the progress layout.
    Non-working datesholidaysColumnOptionalDates that are never working days - public holidays, shutdown weeks. Use a column from the same table as your dates.
    CaptionlabelColumnOptionalText shown above the number.
    Reference timereferenceMeasureOptionalOptional model clock, e.g. UTCNOW(). Used only to correct a viewer device clock that is running behind.
    ActualactualMeasureOptionalHow much is done so far. With Goal and a window, the visual reports the run rate you still need.
    GoalgoalMeasureOptionalThe number Actual has to reach by the deadline.
    TooltipstooltipsMeasureOptionalExtra fields to show in the tooltip.

    Countdowncountdown

    SettingType and options
    Modemode
    • Countdown (to a deadline) countdown
    • Days since (count up) countup
    • Progress (start to end) progress
    • Auto (from the fields) auto
    • Deadline board (many rows) board
    • Milestone track (timeline) track
    • Pace (are we on track) pace
    Date (When No Field Is Bound)staticTargetText
    When The Column Has Many DatestargetPick
    • Next one still ahead nextFuture
    • Latest date latest
    • Earliest date earliest
    • Most recent past date lastPast
    After It Reaches ZeroafterZero
    • Keep counting (overdue by) countup
    • Stop at zero stop
    • Show a message message
    • Roll to the next occurrence roll
    Message At ZerozeroTextText
    Show Tenths Of A SecondshowTenthsOn / off

    Days Sincestreak

    SettingType and options
    Show Current StreakshowCurrentOn / off
    Show Best StreakshowBestOn / off
    Show When The Best Was SetshowBestDateOn / off
    Count IncountIn
    • Calendar days calendar
    • Working days working
    • Shifts shift
    Best-Streak LabelbestLabelTextText
    Current-Streak LabelcurrentLabelTextText

    Deadline Boardboard

    SettingType and options
    Sort Rows BysortBy
    • Soonest first urgency
    • Latest first urgencyDesc
    • Data order data
    • Caption A to Z label
    Overdue Rows FirstoverdueFirstOn / off
    Maximum RowsmaxRowsNumber
    Row HeightrowHeightNumber
    Show Row DividersshowDividerOn / off
    Say How Many Rows Are HiddenshowMoreFooterOn / off
    Show State Chip On Each RowshowRowStateOn / off
    Show The Date On Each RowshowRowDateOn / off

    Milestone Tracktrack

    SettingType and options
    Show The Now MarkershowNowMarkerOn / off
    Show Grid LinesshowGridOn / off
    LabelslabelPlacement
    • Alternating alternate
    • Above above
    • Below below
    • None none
    Marker SizedotSizeNumber
    Show The Date AxisshowAxisLabelsOn / off

    Pacepace

    SettingType and options
    Show The Required RateshowRequiredRateOn / off
    Spread OverrateBasis
    • Calendar days calendar
    • Working days working
    On-Track Band (% Of Goal)onTrackBandNumber
    Show The Projected FinishshowProjectionOn / off
    Show The Gap To PlanshowPlanDeltaOn / off
    Ahead Color (Empty = Theme)aheadColorColour
    Behind Color (Empty = Theme)behindColorColour

    Time Zonetimezone

    SettingType and options
    Deadline Time ZonezoneKind
    • Report viewer's local zone viewer
    • UTC utc
    • Fixed offset offset
    • Named zone iana
    Fixed Offset (e.g. +02:00)fixedOffsetText
    Named Zone (e.g. Europe/Prague)ianaZoneText
    A Day Ends AtdayRollover
    • Local midnight local
    • UTC midnight utc
    Show The Zone On The VisualshowZoneChipOn / off

    Unitsunits

    SettingType and options
    Largest UnitlargestUnit
    • Days d
    • Hours h
    • Minutes m
    • Seconds s
    Smallest UnitsmallestUnit
    • Days d
    • Hours h
    • Minutes m
    • Seconds s
    Hide Seconds Beyond (Hours, 0 = Never)autoCollapseSecondsNumber
    Day CountingbreakdownMode
    • Auto (calendar days) auto
    • Calendar days calendar
    • Exact 24-hour days duration
    Leading ZerosleadingZeros
    • Auto auto
    • Always always
    • Never never
    Language Of The WordsunitLanguage
    • English en
    • Follow the report locale report
    Unit LabelsunitLabelStyle
    • Full words long
    • Short (d h m s) short
    • None none
    Unit Label PositionunitLabelPosition
    • Below the number below
    • Beside the number inline
    Word For DayslabelDayText
    Word For HourslabelHourText
    Word For MinuteslabelMinuteText
    Word For SecondslabelSecondText

    Working TimeworkingTime

    SettingType and options
    Count Working TimeenabledOn / off
    Sundayday0On / off
    Mondayday1On / off
    Tuesdayday2On / off
    Wednesdayday3On / off
    Thursdayday4On / off
    Fridayday5On / off
    Saturdayday6On / off
    Limit To Business HoursbusinessHoursOn / off
    Business Hours Start (HH:MM)businessStartText
    Business Hours End (HH:MM)businessEndText
    Non-Working Dates (One Per Line)holidayDatesText
    Show The Working-Day ReadoutshowWorkingReadoutOn / off

    Recurrencerecurrence

    SettingType and options
    Repeatsunit
    • Does not repeat none
    • Daily day
    • Weekly week
    • Monthly month
    • Quarterly quarter
    • Yearly year
    • End of every month monthEnd
    • End of every quarter quarterEnd
    • End of the fiscal year fiscalYearEnd
    Every NeveryNumber
    Onweekday
    • Sunday 0
    • Monday 1
    • Tuesday 2
    • Wednesday 3
    • Thursday 4
    • Friday 5
    • Saturday 6
    Day Of The MonthdayOfMonthNumber
    Month (Yearly)monthNumber
    At (HH:MM)timeOfDayText
    Fiscal Year Starts In MonthfiscalYearStartMonthNumber

    Stylestyle

    SettingType and options
    Layoutstyle
    • Plain plain
    • Blocks blocks
    • Flip clock flip
    • Ring ring
    • Bar bar
    • One line inline
    Separatorseparator
    • Auto (theme) auto
    • Colon : colon
    • Dot · dot
    • Slash / slash
    • None none
    Blink The SeparatorseparatorBlinkOn / off
    Ring ThicknessringThicknessNumber
    Bar HeightbarHeightNumber
    Animationanimation
    • Auto (theme) auto
    • None none
    • Fade fade
    • Flip flip

    Texttext

    SettingType and options
    FontfontFamily
    • Inter inter
    • Segoe UI segoe
    • Arial arial
    • Georgia georgia
    • Monospace mono
    Fit The Number To The VisualautoFitOn / off
    Number SizevalueSizeNumber
    Unit Label SizeunitSizeNumber
    Caption SizecaptionSizeNumber
    Alignmentalign
    • Center center
    • Left left
    • Right right
    Number Color (Empty = Theme)valueColorColour
    Unit Label Color (Empty = Theme)unitColorColour
    Caption Color (Empty = Theme)captionColorColour

    Statesstates

    SettingType and options
    Show State IconshowIconOn / off
    Show State LabelshowStateLabelOn / off
    Warning When WithinwarningValueNumber
    Warning UnitwarningUnit
    • Days d
    • Hours h
    • Minutes m
    Critical When WithincriticalValueNumber
    Critical UnitcriticalUnit
    • Days d
    • Hours h
    • Minutes m
    Normal Color (Empty = Theme)normalColorColour
    Warning Color (Empty = Theme)warningColorColour
    Critical Color (Empty = Theme)criticalColorColour
    Overdue Color (Empty = Theme)overdueColorColour
    Warning LabelwarningTextText
    Critical LabelcriticalTextText
    Overdue LabeloverdueTextText

    Captioncaption

    SettingType and options
    Show CaptionshowLabelOn / off
    Caption Text (Empty = From Data)labelTextText
    Show The Target DateshowTargetOn / off
    Target Date FormattargetFormat
    • Date and time dateTime
    • Date only date
    • Long date full
    Show "As Of" Stamp In ExportsshowAsOfOn / off

    Themetheme

    SettingType and options
    ThemeselectedTheme
    • SmartVisuals smartvisuals
    • Dark dark
    • Clean clean
    • Slate slate
    Background Color (Empty = Theme)bgColorColour
    Transparent BackgroundtransparentBgOn / off

    Diagnosticsdiagnostics

    SettingType and options
    Warn About Rows That Are Not DatesshowSkippedOn / off
    Show Where The Clock Comes FromshowClockConfidenceOn / off

    Setting a value in PBIR

    In a visual.json, a setting goes under visual.objects, by card and internal name. Toggles take true or false, choices and text a value in single quotes ('auto'), numbers a D suffix (12D).

    "visual": {
      "visualType": "countdownTimer1F116F5EB2844AFDA3D921F4012C0E5C",
      "objects": {
        "countdown": [{
          "properties": {
            "showTenths": { "expr": { "Literal": { "Value": "true" } } }
          }
        }]
      }
    }