How to Create a Date Hierarchy in Power BI

‍

‍

Here’s how to do it:

‍

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.