Date Hierarchy is not working in calender not working

[Anonymous]

I Have created a date hierarchy to show data in year , quarter, date, Day in Power Bi, it is not working currently.

it should not be like this.  showing only three options below.

it should be like this. 

Thanks,

Raj

[Anonymous]

Hi @Anonymous ,

Sorry to disturb you...

But did I answer your question ? Please mark my reply as solution. Thank you very much.

Best Regards,
Stephen Tao

[Anonymous]

Hi @Anonymous ,

Seems like it depends on how the relationship is configured. See attached PBIX. 

Reference: Date hierarchy not available

Best Regards,

Stephen Tao

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

[Fowmy]

@Anonymous 

If you create a hierarchy manually for dates, that option will not be there. To have that option you need to enbale Auto Date Time