Forum Discussion
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.
can you check this I already shared you the screenshot of dtype.
- Pragati11
Super User
Hi Nalandeep ,
Apologies I missed it.
Then only one thing I can think of is your conncetion type could be direct query to your data source. That's what is disabling your date hierarchy.
Are you able to share your pbix file?
sorry to say this but its confidential data of our company I cant share it.
- Pragati11
HI Nalandeep ,
Unfortunately, I can't think of any other way at this stage.
- You have Auto-datetime enabled in PBI Desktop
- You don't have DirectQuery connection mode
3 more questions:
- Do you have any relationships in the model on this DATE column?
- Do you have a Calendar or Date table in your data model that is marked as DATE table?
- What version of PBI Desktop are you using?
