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.

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

joglidden2 , Please make sure it is checked at the report level. If yes, it should generate for all the dates not joined to the date table (marked as date table).

 

Make sure you are using latest version of power bi and no windows patch is pending

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

    Yes, good question. 'Time Intelligence' was checked for both current file and global. I should have been clear that I checked both.