logo
For Power BI
  • Products
    • Drill Down Donut Pro Drill Down Donut PRO
    • Drill Down Pie Pro Drill Down Pie PRO
    • Drill TimeSeries Pro Drill Down TimeSeries PRO
    • Drill Combo Pro Drill Down Combo PRO
    • Drill Map Pro Drill Down Map PRO
    • Drill Scatter Pro Drill Down Scatter PRO
    • Drill Down Network Pro Drill Down Network PRO
    • Drill Down Waterfall Pro Drill Down Waterfall PRO
    • Drill Down Graph Pro Drill Down Graph PRO
    • Drill Down Timeline Pro Drill Down Timeline PRO
    • Drill Down Combo Bar PRO Drill Down Combo Bar PRO
    • Drill Down Line PRO Drill Down Line PRO

    Video tutorials

    Watch Now

    More than 90 videos on how to enhance Power BI with ZoomCharts

    Learn more
    All visuals
  • Resources

      Resources

    • Documentation
    • Report Examples
    • Blog
    • Webinars
    • Video Tutorials
    • Visuals Gallery

    Support

    • ZoomCharts Assistance
    • Contact Sales
    • Contact Support
    • FAQ

    Challenges

    Challenges

    Improve your report creation skills by participating in free challenges for report creators.

    Learn more
    Start trial
  • Services
    • Power BI Report Development
    • Custom Visual Development
  • Challenges
  • Pricing
Request a quote Start Free Book a Demo Sign in
Request a quote Start Free Book a Demo Sign in
Get it now
Go back

Contents

ZoomCharts Documentation

Up Down
Edit Category
Delete Save Add Child

Supported date/time hierarchy column names

Date/time columns should be named according to the following convention to be correctly interpreted by the visual - 'X unit', where:

'X' is a whole number, followed by a space;
'unit' is a valid date/time unit from the list below.


Here is the full list of the supported date/time units and numbers of units:

milliseconds:

'1 ms', 'ms', 'millisecond', 'milliseconds',
'5 ms', '5 milliseconds',
'10 ms', '10 milliseconds',
'20 ms', '20 milliseconds',
'50 ms', '50 milliseconds',
'100 ms', '100 milliseconds',
'250 ms', '250 milliseconds',
'500 ms', '500 milliseconds'


seconds:

'1 s', 'sec', 'second', 'seconds',
'2 s', '2 seconds',
'3 s', '3 seconds',
'4 s', '4 seconds',
'5 s', '5 seconds',
'10 s', '10 seconds',
'15 s', '15 seconds',
'20 s', '20 seconds',
'30 s', '30 seconds'


minutes:

'1 m', 'min', 'minute', 'minutes',
'2 m', '2 minutes',
'3 m', '3 minutes',
'4 m', '4 minutes',
'5 m', '5 minutes',
'10 m', '10 minutes',
'15 m', '15 minutes',
'20 m', '20 minutes',
'30 m', '30 minutes'


hours:

'1 h', 'hour', 'hours',
'2 h', '2 hours',
'3 h', '3 hours',
'4 h', '4 hours',
'6 h', '6 hours',
'12 h', '12 hours'


days:

'1 d', 'day', 'days', 'dayofmonth',
'2 d', '2 days',
'3 d', '3 days',
'4 d', '4 days',
'5 d', '5 days',
'6 d', '6 days',
'10 d', '10 days',
'14 d', '14 days',
'15 d', '15 days'


weeks:

'1 w', '1 week', 'week',
'2 w', '2 weeks',
'3 w', '3 weeks',
'4 w', '4 weeks',
'5 w', '5 weeks',
'6 w', '6 weeks',
'8 w', '8 weeks',
'10 w', '10 weeks',
'12 w', '12 weeks',
'16 w', '16 weeks',
'24 w', '24 weeks'


months:

'1 M', 'mon', 'month', 'months',
'3 M', '3 months', 'quarter', 'quarters',
'2 M', '2 months',
'4 M', '4 months',
'6 M', '6 months'


years:

'1 y', 'year', 'years',
'2 y', '2 years',
'3 y', '3 years',
'5 y', '5 years',
'10 y', '10 years', 'decade'


If any of the above is not clear, does not work as expected even if you followed the setup step-by-step, or you would like us to add even more units or configuration options, please contact [email protected]

Was this helpful? Thank you for your feedback!

Sorry about that.

How can we improve it?

logo
[email protected]
+44 204 577 3993
logo

Products

Drill Down Network PRO Drill Down Waterfall PRO Drill Down Graph PRO Drill Down Combo PRO Drill Down Combo Bar PRO Drill Down Donut PRO Drill Down Pie PRO Drill Down TimeSeries PRO Drill Down Timeline PRO Drill Down Map PRO Drill Down Scatter PRO All Visuals

Resources

Report Examples Webinars Blog ZoomCharts Academy Visuals Gallery Documentation Custom Visual Development Subscribe to News

Solutions

Custom Visual Development

Company

Pricing About Us Partners Leave feedback Join PowerGroup EU Funding

Help

ZoomCharts Assistance Contact Sales Contact Support FAQ

Drill Down Network PRO Drill Down Waterfall PRO Drill Down Graph PRO Drill Down Combo PRO Drill Down Combo Bar PRO Drill Down Donut PRO Drill Down Pie PRO Drill Down TimeSeries PRO Drill Down Timeline PRO Drill Down Map PRO Drill Down Scatter PRO All Visuals

Report Examples Webinars Blog ZoomCharts Academy Visuals Gallery Documentation Custom Visual Development Subscribe to News

Custom Visual Development

Pricing About Us Partners Leave feedback Join PowerGroup EU Funding

ZoomCharts Assistance Contact Sales Contact Support FAQ
+44 204 577 3993
[email protected]

Ready to get in touch?

Contact our experts with any question about Power BI and ZoomCharts for Free!

Contact us

© 2025, Data Visualization Software Lab

U.S. Patents No. 11,645,343; 11,921,804

Cookies Policy
Manage cookies
Privacy Policy
Global
EULA
Patent
warning

Error message

success

Success info: Done!

ZoomCharts AI Assistant

We noticed you're using an old OS version.

For the best experience, we recommend upgrading to ensure that all website features display correctly.