Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
Hi everyone,
I had a dataset where the date fields were coming from an oracle database and they were as number. After having my dataset done, with relationship and all tables, I changed all date fields in my dataflow to date datatype.
The problem is that the fields are coming correctly as a date, but even refreshing, I don't have the date hierarchy. Will it be necessary to create the entire dataset and relationships again?
Note: these fields are not present in any relationship, only other fields in the tables. Also all time intelligence settings are enabled in options.
Hi @hama21 ,
What is the relationship between your tables?
When the relationship is one-to-many, Power BI will respect your decision and remove the "many" side date hierarchy.
This blog discusses this issue in great detail, please check it out. Hope it will help you!
Why there is no date hierarchy - Microsoft Power BI Community
Best Regards,
Jianbo Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@hama21 , if you joined your date with the date of date/calendar table marked as date table, then date will not show hierarchy.
It is a good idea to use date table and not use the default hierarchy. Create a custom one if needed
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
Custom Hierarchy
https://stoneridgesoftware.com/creating-hierarchies-in-power-bi/
https://www.youtube.com/watch?v=x6vXVJZ_eTY
@amitchandak I'm not using any date table. Another fields that is date time came with default hierarchy, just the fields that I changed the data type and refreshed the dataset it's not working.
And also if I create a new report importing the same table again, all fields now it's with default hierarchy. Just in the dataset that I already had, it's not working.
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
94 | |
92 | |
83 | |
71 | |
49 |
User | Count |
---|---|
143 | |
120 | |
111 | |
59 | |
57 |