Forum Discussion
sraj
Responsive Resident
Responsive ResidentDate - Data type
Hi Everyone, My Date Created field/option is not showing the hierarchy calendar, the data type is set to Date but its still not showing for me to get the Year, Month, Day options. Can someone pl...
Found the issue, I had my data connectivity mode to "DirectQuery" once I changed it to "Import" I was able to see the calendar and the date hierarchy. This is strange that it doesnt work for both the modes, anyways I am glad I tried this. Thank you!!
Hello sraj ,
Sometimes it won't create date hierarchy. probably you can create column for year, month, querter, day and create new hierarchy.
srajResponsive Resident
Responsive ResidentFound the issue, I had my data connectivity mode to "DirectQuery" once I changed it to "Import" I was able to see the calendar and the date hierarchy. This is strange that it doesnt work for both the modes, anyways I am glad I tried this. Thank you!!