# How to Create a Date Hierarchy in Power BI

> To create a date hierarchy in Power BI, go to Options and settings, select Options, navigate to Current file and Data load, ensure Auto Date/Time is enabled under Time intelligence, and click OK.

Canonical: https://livedemo.ai/tutorials/how-to-create-a-date-hierarchy-in-power-bi/
Apps: Power BI
Updated: 2026-10-05
Interactive demo: https://story-api.livedemo.ai/workspaces/62255d3d3304f17b8f5e2d03/stories/692a36b7ab56e05a00fdba2d/preview?step=1

## Steps

1. Go to 'Options and settings'.
2. Select 'Options'.
3. Navigate to the 'Current file' section and select 'Data load'.
4. Go to the 'Time intelligence' option and make sure 'Auto Date/Time' is enabled in the options.
5. Click 'OK' to proceed.
6. That's it! You have now created a date hierarchy in Power BI.