Date Hierarchy not avaible for one date field

[etiennemichelet]

Hi,

I have multiple date fields in my dataset but the date hierarchy is not working for one of them. I think I did something to disbale it for this fields but I am not sure what or how. Is there a way I can re-enable it?

See below ot is enabled for Despatch date but not Invoice trasaction date.

Regards,

Etienne

[v-xicai · Accepted solution]

Hi @etiennemichelet ,

You may have created relationship between another table using the date [Invoice trasaction date].

When you created the relationship (Many to one or one to Many) between the tables with Date, only the date in the one side will show date hierarchy. 

So if you want to the date in your fact table show date hierarchy, you could create one to one relationship , or just to create relationship which put the date [Invoice trasaction date] of fact table in one side instead of the many side.

You can refer to the similar case: https://community.powerbi.com/t5/Desktop/Date-hierarchy-not-available/td-p/438804.

Best Regards,

Amy

Community Support Team _ Amy

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

[Tad17]

This is good to know. Thanks @v-xicai 

[etiennemichelet]

Hi Amy,

That was it, thanks. I removed the table as I didn't need it and the hierarchy is there now.

Thanks a lot,

Etienne

[amitchandak]

First Check the datatype in dataview

Refer solution, you can enable it again

https://community.powerbi.com/t5/Desktop/Date-Hierarchy-Not-Available/td-p/490683

Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blog -
https://community.powerbi.com/t5/Community-Blog/Winner-Topper-on-Map-How-to-Color-States-on-a-Map-wi...
https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...
https://community.powerbi.com/t5/Community-Blog/Power-BI-Working-with-Non-Standard-Time-Periods/ba-p...
https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601

[etiennemichelet]

Thanks. I've checked this and both the fields are in the same format. I've also checked the Auto date/time is enabled too.

Is there any other way to force enable this?

[Tad17]

In that case we will probably need to see some of the data to really be able to tell what is going on. 

You can always create a new hierarchy for the field though.