How to Create a Date Hierarchy in Power BI
- George Apostolov
How to Create a Date Hierarchy in Power BI: step-by-step 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.
Quick answer: 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.
About this Power BI tutorial
Set up a date hierarchy in Power BI by enabling the Auto Date/Time feature in your file options to automatically organize your data. This guide shows how to create a Date Hierarchy in Power BI in 6 steps, starting with "Go to 'Options and settings'" and finishing with "That's it! You have now created a date hierarchy in Power BI". The interactive demo above is a click-through copy of the real Power BI interface, so you can rehearse each step before doing it in your own account.
Frequently asked questions
How many steps does it take to create a Date Hierarchy in Power BI?
6 steps. Each one is listed in order above, and the demo highlights exactly where to click.
Can I try it without changing my own account?
Yes. Clicking through the demo doesn't touch your Power BI data or settings. Once you know the flow, repeat it in your own workspace.
This tutorial is filed under Power BI. Related guides: How to Create a Date Table in Power BI, How to Create a Drill Through in Power BI and How to Create a Gauge in Power BI. Last reviewed 05 Oct 2026.
Create your first interactive demo in minutes
No credit card required • Start building today
