Date Hierarchy missing

[praveenurs]

I have a calendar table linked to a Calls table, i am trying to get the day-wise calls, however it doesnt seem to work!

The Start Date and time field data type set to Date time 

As you can see below the date hierarchy in calls table goes missing once i link the two tables, i am using the day field  from the calendar table in axis and the count of phoneno field in Values field, why isnt it working?

The slicer is referncing the fields from Calendar table 

Please help, TIA 

@Mariusz 

[amitchandak]

@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

[praveenurs]

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!

[MCornish · Accepted solution]

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