How to Create a Date Hierarchy in Power BI
- George Apostolov
- 05 Sep 2025
Guide
Go to 'Options and settings'.
Select 'Options'.
Navigate to the 'Current file' section and select 'Data load'.
Go to the 'Time intelligence' option and make sure 'Auto Date/Time' is enabled in the options.
Click 'OK' to proceed.
That's it! You have now created a date hierarchy in Power BI.
Create your first interactive demo in minutes
No credit card required • Start building today
