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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

July 2024 Power BI Update

Power BI Monthly Update - July 2024

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

July Newsletter

Fabric Community Update - July 2024

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