data format

Hi  AlessandroBet ,

In Power BI Desktop, you select File > Options and settings > Options, and then select either the Global or Current File page. On either page, the option exists in the Time intelligence section.

There are also restrictions on date hierarchies:

• The table storage mode is Import
• The column data type is date or date/time
• The column isn't the "many" side of a model relationship

Refer to：

Why there is no date hierarchy - Microsoft Power BI Community

There is also a workaround:

You can  create four calculated columns to extract the  "Year," "Quarter," "Month“,” Day " from column"Date".

Then you can manually create new Heirarchy, by right-clicking on the date, then drag in the other pieces you need ("Year," "Quarter," "Month“,” Day, ").

Year = YEAR('Annual Days'[Date])

Quarter = QUARTER('Annual Days'[Date])

Month = MONTH('Annual Days'[Date])

Day = DAY('Annual Days'[Date])

Click [Date] – Create hierarchy

Add four columns to the hierarchical results

[Day] – Add to hierarchy – Date Hierarchy.

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.