Forum Discussion
Date Hierarchy missing
I would start by spliting your "Start Date And Time" into "Start Date" and "Start Time" columns. Otherwise you will have a Date data type looking at a datetime data type.
That would be my starting position
praveenurs , These are the reasons Date Hierarchy can be missing
https://community.powerbi.com/t5/Desktop/Date-Hierarchy-Doesn-t-show/td-p/525460
https://community.powerbi.com/t5/Desktop/Date-hierarchy-not-available/td-p/438804
https://community.powerbi.com/t5/Desktop/Lost-Missing-Date-Hierarchy/td-p/421045
Check Settings
https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-auto-date-time
You can create a new hierarchy
https://www.tutorialgateway.org/create-hierarchy-in-power-bi/
https://www.youtube.com/watch?v=x6vXVJZ_eTY
Checked the above, still not able to solve
Check the below, this means there's no match between the two however the calls dates are in fact between the calendar dates!
