Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Date Hierachy Missing

Hello All,

 

The Date Hierachy is not showing up in my BI reports on Desktop. I checked sttings and Time intelligence is checked. How can I add to manually to fix? 

 

 

 

 

 

 

 

Need Help
Show and Tell
  • v-jingzhang's avatar
    v-jingzhang
    4 years ago

    Hi Anonymous 

     

    This blog should be helpful: Why there is no date hierarchy - Microsoft Power BI Community

     

    To see the auto date hierarchy, you need to ensure the following 5 conditions:

    • Enable automatic date/time option
    • 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
    • No table is marked as date table

     

    Best Regards,
    Community Support Team _ Jing
    If this post helps, please Accept it as Solution to help other members find it.

6 Replies

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

    Anonymous , I think the option is there at both global and report levels. check at the report level too.

    Also, when the date is joined with the date(which is key) in the date table, marked as a date table. It will not show hierarchy. You can duplicate the join column and check

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      What do you mean by duplicating join column?

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Forgive me but where do I check report levell settings? Ex. Go to desk top =>File => options settings =>options => ?

    • Samarth_18's avatar
      Samarth_18
      Icon for Community Champion rankCommunity Champion
      4 years ago

      Anonymous  Yes under current file you check for below option:-

      • Anonymous's avatar
        Anonymous
        Not applicable
        4 years ago

        Its checked in the Data Load already.

  • v-jingzhang's avatar
    v-jingzhang
    Icon for Community Support rankCommunity Support
    4 years ago

    Hi Anonymous 

     

    This blog should be helpful: Why there is no date hierarchy - Microsoft Power BI Community

     

    To see the auto date hierarchy, you need to ensure the following 5 conditions:

    • Enable automatic date/time option
    • 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
    • No table is marked as date table

     

    Best Regards,
    Community Support Team _ Jing
    If this post helps, please Accept it as Solution to help other members find it.