Forum Discussion

joglidden2's avatar
joglidden2
Icon for Post Patron rankPost Patron
4 years ago
Solved

Date Heirarchy won't create

I have a date field, and yes, it's set to date data type under column tools. I have the obscure little 'Time intelligence' box check in settings. Data source is direct query. Every time I go to gener...
General Comment
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • v-yalanwu-msft's avatar
    v-yalanwu-msft
    4 years ago

    Hi, joglidden2 ,
    https://community.powerbi.com/t5/Community-Blog/Why-there-is-no-date-hierarchy/ba-p/2266682

     

    Now 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.

v-yalanwu-msft's avatar
v-yalanwu-msft
Icon for Community Support rankCommunity Support
4 years ago

Hi, joglidden2 ,
https://community.powerbi.com/t5/Community-Blog/Why-there-is-no-date-hierarchy/ba-p/2266682

 

Now 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.