Date hierarchy not showing

[KRISHI02]

I have multiple table containg 'DATE' column (date in 'DATE' column are same for all table). So I created one table using 'DATE' column from one of the table called 'DATE TABLE'.  

All the 'DATE' column data type is 'date'.

why 'DATE TABLE' date column is not appearing in hierarchy form.

In Time intelligance , Auto date/time is also ticked.

[bhanu_gautam · Accepted solution]

@KRISHI02 , There are certain points that you can check

Sometimes, even if the data type is set correctly in the source, Power BI might not recognize it as such. You can check and change the data type in Power BI by selecting the column and setting its data type to "Date" in the "Modeling" tab.

Auto Date/Time for New Files: Power BI has a setting called "Auto Date/Time for new files" which, if disabled, might prevent the automatic creation of date hierarchies. You can check this setting by going to File > Options and settings > Options > Data Load and ensuring that "Auto Date/Time for new files" is enabled.

Column Properties: Ensure that the column properties in Power BI are set correctly. Sometimes, the column might be set to a different data type or format that does not support hierarchies. You can adjust this in the "Modeling" tab.

If it still does not work you can add hirearchy manually

Go to the "Model" view.
Right-click on the table containing the date column.
Select "New hierarchy" and add the date column to this hierarchy.
You can then add additional levels to this hierarchy, such as year, quarter, month, and day.