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
Nalandeep's avatar
Nalandeep
Regular Visitor
3 years ago

none of the Date column showing hierarchy.

  • Pragati11's avatar
    Pragati11
    Super User
    3 years ago

    Nalandeep 

    I can't think of anythign else as I don't see this behaviour at my end. Date column hierarchy shows up when Auto-datetime option is enabled at BOTH places in the Power BI settings.

    I am pulling data from an excel file in the Power BI Desktop.

     

    One last thing to check is, can you share a screesnhot of the Data Source Settings in Power BI. You will see something like below:

     

     

  • Nalandeep's avatar
    Nalandeep
    Regular Visitor
    3 years ago

    how this is related to that issue can you please explain.

     

  • Pragati11's avatar
    Pragati11
    Super User
    3 years ago

    Hi Nalandeep ,

     

    I am just trying to understand the data sources you are connected to whether they are locally on your machine like excel files or somewhere in the cloud like sharepoint list. 🙂