date field not generates hierarchy

[Giada_Togliatti]

Hi,

I have a date field that not generates hierarchy, while I have other date fields thast generate hierarchy..how can I do?

Thank you

[FrankAT]

Hi @Giada_Togliatti ,

it is highly recommended to use your own date table as a dimension and to switch off the automatism of hierarchy formation for columns with date values (see figure).

With kind regards from the town where the legend of the 'Pied Piper of Hamelin' is at home
FrankAT (Proud to be a Datanaut)

[amitchandak · Accepted solution]

@Giada_Togliatti , If you have an auto datetime checked (in options and setting) then you should get the date hierarchy.

But if it is a key field, you might miss that

These are the reasons Date Hierarchy can be missing
https://community.powerbi.com/t5/Desktop/Date-Hierarchy-Doesn-t-show/td-p/525460
https://community.powerbi.com/t5/Desktop/Date-hierarchy-not-available/td-p/438804
https://community.powerbi.com/t5/Desktop/Lost-Missing-Date-Hierarchy/td-p/421045