Forum Discussion
Date Hierarchy missing
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
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
3 Replies
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/421045Check Settings
https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-auto-date-timeYou can create a new hierarchy
https://www.tutorialgateway.org/create-hierarchy-in-power-bi/
https://www.youtube.com/watch?v=x6vXVJZ_eTYChecked 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!
