Forum Discussion

Nalandeep's avatar
Nalandeep
Regular Visitor
3 years ago

Date Hierarchy

I have created date hierarchy using date type column but suddenly I am not able to create that hierarchy and also cant see calender logo in front of date column.

Need Help
Show and Tell

20 Replies

    • Pragati11's avatar
      Pragati11
      Super User
      3 years ago

      HI Nalandeep ,

       

      Can you click one of these columns and share a screenshot on what is the data-type of Date column in  the People table?

      Another question is - What is the data connection mode in Power BI? Is it DirectQuery connection?

       

  • Pragati11's avatar
    Pragati11
    Super User
    3 years ago

    HI Nalandeep ,

     

    Go and check the Auto datetime settings in POwer BI Desktop.

    Navigate to File --> Options & Settings --> Options:

    Make sure this option is enabled here.

     

    Then also see the option is enabled here:

    Once the option is enabled at both places, you will see your date hierarchy back.

     

  • Nalandeep's avatar
    Nalandeep
    Regular Visitor
    3 years ago

    Both the options are enabled still not getting for other dashboard and data i can see that but specially for this data its not showing.

     

    • Pragati11's avatar
      Pragati11
      Super User
      3 years ago

      HI Nalandeep ,

       

      Can you please add some screenshots here please regarding your issue?