Forum Discussion
Post PatronDate Heirarchy won't create
Hi, joglidden2 ,
https://community.powerbi.com/t5/Community-Blog/Why-there-is-no-date-hierarchy/ba-p/2266682Now let's see what we need to be aware here regarding the date hierarchy.
- Enable automatic date and time
- 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
When the above conditions are met, the date hierarchy will work for you.
because your data source is Direct query, so it won't wok.
Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Community SupportHi, joglidden2 ,
If you have not enabled this option, then you need to enable this option first.
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.
Reason 2:
When a date field is related to another non-date field (such as an integer type Date Key field). Power BI still removes the hierarchy of fields on Many side of a one-to-many relationship.
https://community.powerbi.com/t5/Community-Blog/Why-there-is-no-date-hierarchy/ba-p/2266682
Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- joglidden2
Good question, and thanks for the link. Yes, the table that I'm trying to create the date heirarchy on is on the many side of a one-many relationship. However, it is not the date field that forms the relationship. See screenshot: in red I've underlined the integer fields that form the relationship, and in blue the date field that I'm attempting to create the heirarchy with. According to the article link, this should still be allowed.
