Date Hierarchy gone after marking as date table

[APM]

Hi,

I recently created a custom calendar in PowerBi as a new table. 

It auto-generated a date hierarchy:

However, once I went into the 'Date' table I created and hit "Mark as Date Table', it removed that very perfect hierarchy and this now appears:

When I right-click on it to create a new hierarchy, this appears (essentially more of the same and no hierarchy):

I want to be able to use the time intelligence functions, but marking as a date table removed the very convenient grouping. 

Does anyone know how I can fix this?

Thanks!

[Berlin_Samuel7]

THANK YOU. VERY HELPFUL.

[v-kelly-msft · Accepted solution]

Hi @APM ,

You need to first create 4 columns:Year,Quarter,Month,Day:

Then right click on ...of year column:

choose "New hierarchy";

Then rename it as "Date hierarchy";

Right click ...of other 3 columns>"Add to hierarchy":

And you will see the complete date hierarchy as you wish.

Check the reference below:

https://spreadsheeto.com/power-bi-hierarchy/

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

[amitchandak]

@APM , If you mark Table as Date table, Date will become Key and you will not be able to use date hierarchy. It is expected behavior