Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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
@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!
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
100 | |
78 | |
64 | |
58 |
User | Count |
---|---|
148 | |
113 | |
97 | |
84 | |
67 |