Forum Discussion

Alex_Ooi's avatar
Alex_Ooi
Icon for Helper IV rankHelper IV
6 years ago
Solved

Date Hierarchy missing in Dec 2019 release?

Hi folks, I am now not able to have the DATE HIERARCHY feature enabled (I never had this issue before Dec 2019 release).

I have tried a couple of solutions and none of them worked:

 

Created a calendar table using CALENDAR function - failed

Mark data table as date table - failed

Mark calendar table as date table - failed

Go to File > Options & Settings > Options > Preview features - no such feature is there that enables date hierarchy

 

I do not want to create my own hierarchy by using year / month / date because I feel that is not doing justice to whatever feature was previously there. Can someone please guide me?

Need Help

6 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi Alex_Ooi ,

     

    Please refer https://community.powerbi.com/t5/Desktop/date-hierarchy-missing/m-p/887555.

    No hierarchy will be created 

    • when the date table on the Many side relationship
    • In Direct Query connections

    Otherwise, please try update Power BI Desktop to latest version and see if the issue still exists.

     

    Best Regards,

    Jay

    Community Support Team _ Jay Wang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    • Alex_Ooi's avatar
      Alex_Ooi
      Icon for Helper IV rankHelper IV
      6 years ago

      Hi Anonymous thank you for the response. I have read that article, and it didn't work too. In fact, I created a connection from date table to the data table, and I used the [Date] field from date table (not data table). This too, failed to work.

       

      Also, can I know how would I know which is the latest Power BI Desktop version? I am currently running on

      Version: 2.76.5678.782 64-bit (December, 2019)

       

      The update notification on my machine is greyed out - I assume the app would have automatic update, which means I am already having an up-to-date version as we speak? Please advise.

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        Hi Alex_Ooi ,

         

        I have the same Power BI Desktop version with you and my date hierarchy feature is working fine.

        If you are using one to many relationship, the "many" side date hierarchy won't work.

        Try open a new pbix and create a single date table and check if you can use date hierarchy, if not, you might need to reinstall your Power BI Desktop.

         

        Best Regards,

        Jay

        Community Support Team _ Jay Wang

        If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.