xViz
ProductPricingCommunity
  • Welcome to xViz Docs!
  • Project Management
    • Project Management - xViz Gantt Chart | Introduction
    • Hierarchy and Additional Columns
    • 🔸Milestones
      • Milestone Formatting
    • Planned Bars
      • Planned Bars Formatting
    • Connectors
      • Primary & Secondary Connectors
      • Multiple Connectors
      • Connectors Formatting
    • Progress
      • Tracking the progress
      • Progress Bar Display
      • Progress Base
      • Bar Formatting
    • Timeline Configurations
      • Timeline Start/End
      • Timeline Range
      • Header Levels
      • Zoom Levels
      • Zoom Options
      • Fiscal Year Support
      • Timeline Format
      • Language Support for Timeline
    • ✨Alerting Techniques
      • Steps to enable Conditional Formatting
      • Conditional Formatting
    • Reference Lines and Reference Range
      • Introduction
      • Static Approach
      • Data Driven Approach
    • Resource Gantt
    • ➡️Other Features
      • Data Colors
        • Row Background Color
        • Bar Border Color
        • Bar Selection Color
        • Bar Fill Color
        • Connectors
      • Duration Data field
      • Display Duration
      • Display Totals
      • Hide Blanks
      • Date Formats
      • DaysOff
        • Weekday
        • Custom Date
      • Setting Up Drill-through
      • Configure External URLs
      • Splitter Position
      • Text Customization
      • Row Numbering
      • Indentation
      • Sorting
    • Parent Level Calculations
      • Aggregation Types
    • Tooltip
    • Release Notes
    • ❓FAQs
  • Performance Management
    • Performance Flow - Introduction
      • Installing from AppSource
      • Get Started
    • Use Cases
      • Organization Performance
      • Microsoft Tenant Data Analytics
        • Organization Chart using Microsoft Graph API
      • Process Flow
      • Sales Performance Analysis
      • Cost Center Analysis
      • KPI Tree
      • Warehouse Management
      • Supply Chain Network
    • Configuring the chart structure
      • Hierarchy structure
      • Grouping / Swim Lanes
        • Data Structure for Columnar Group View
        • Data Structure for Wide Group Views
      • Invisible Group
    • 🪪Display Data in the Cards
      • Title, Subtitle
      • 👨‍💼Images
        • Converting HTTPs link images/icons to Base 64 in Power BI
        • Handling long Base 64 URLs in Power BI
      • 🔢Displaying KPIs
        • Number Formatting
      • 🔻Displaying Variance
      • Sparkline Trends
      • 🔗Hyperlinks
    • Card Formatting
      • Data-Driven Color
      • Templates
      • Customize Template
        • Insert additional data
        • Alignment
        • Wrap Text
        • Styling
        • Margin & Split
        • Modify (Delete / Cope-Paste)
        • Import/Export
    • Links
    • 🗒️Notes & Annotation
    • 🚦Conditional Formatting
    • Layout & Orientation
    • ✨Search
    • ✨Viewing Subtrees
      • Cross Filtering with Subtrees
    • 🔐✨User Context - RLS Experience
    • ✨Filter Context
    • 🎨Formatting Features
      • Formatting Font & Colors
      • Connectors
      • Expand Collapse Button
      • Dimensions
    • Toolbar Ribbon Configuration
    • Simulation
    • ❓FAQs
      • Circular Dependency message
    • Tips & Tricks
      • Bookmark
      • Report Page Tooltip
      • Field Parameters
      • Drill Through
    • Release Notes
Powered by GitBook
On this page
  • Steps to format dates for Timeline:
  • Format Keywords:
  • Template to format Timeline Header:

Was this helpful?

  1. Project Management
  2. Timeline Configurations

Timeline Format

PreviousFiscal Year SupportNextLanguage Support for Timeline

Last updated 8 months ago

Was this helpful?

The xViz Gantt Chart offers formatting options for dates in the timeline header.

Steps to format dates for Timeline:

  1. Go to the Advance Editor

  1. Then, navigate to the Timeline tab, where you will find the Format text box located below the Interval text box.

  1. Afterwards, you can format the date to determine how dates are displayed on the timeline header.

The final result, the timeline header is formatted, is displayed in the image below:

Format Keywords:

Below are the format keywords for customizing the timeline, along with an example. In this example, the date is August 6, 2024, 3:05:02 AM, and week start is set to Monday. Note that the format keywords are case sensitive.

Format

Notes

Result

YYYY

4-digit year

2024

YY

Last 2 digits of the year

24

MMMM

Full month name

August

MMM

3-letter month abbreviation

Aug

MM

Month number with leading zeros

08

M

Month number without leading zeros

8

Q

Quarter number

3

w

Week number of the year without leading zeros

32

ww

Week number of the year with leading zeros

32

D

Day of the month without leading zeros

6

DD

Day of the month with leading zeros

06

ddd

3-letter weekday abbreviation

Tue

dddd

Full weekday name

Tuesday

h

12-hour clock without leading zeros

3 AM

hh

12-hour clock with leading zeros

03 AM

H

24-hour clock without leading zeros

3

HH

24-hour clock with leading zeros

03

m

Minutes without leading zeros

5

mm

Minutes with leading zeros

05

s

Seconds without leading zeros

2

ss

Seconds with leading zeros

02

Template to format Timeline Header:

Combine keywords with additional words encapsulated in double quotes.

Format

Result in Timeline

Notes

"Q"Q

Q3

The Q between double quotes is extra text

YYYY

2024

MMM

Aug

MMM" "DD", "YYYY

Aug 06, 2024

Comma is added here, similarly any other text or symbols can be added in between double quotes

Note: If the header format is set to 'Combined' or 'Days' in the Timeline options of the Format pane, then the Format text boxes will not appear in the Timeline tab.

Image 1: Timeline formatting with xViz Gantt Chart
Image 2: Advance Editor icon
Image 3: Format text box in Timeline tab
Image 4: Format Timeline
Image 5: Timeline formatting with xViz Gantt Chart