Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
hama21
Frequent Visitor

Date datatype not showing date hierarchy

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.

3 REPLIES 3
v-jianboli-msft
Community Support
Community Support

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.

amitchandak
Super User
Super User

@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.

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.