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

Data Days is here! Join us now for 60+ days of learning, challenges, and connection. Learn more

Reply
ArchStanton
Power Participant
Power Participant

Unable to Create Date Hierarchy

I have many date columns in my fact table that have inactive relationships with my Calendar. Once upon a time they all had Date Hierarchies but I got rid of them as I was worried about performance and cost to the huge Data Model that I have, unfortunately, now I want to reintroduce one of them but no matter what I try it doesn't work. (I can't remember exactly how I removed the hierarchies)!
One such date field is called the application validation date column, when I right click in Model viewer to create a Date hierarchy nothing happens, all I see is this:

ArchStanton_0-1779275452347.png

 My Global settings have Time Intelligence ticked and so does my Current File

 

Global:

ArchStanton_1-1779275521972.png

Current File:

ArchStanton_2-1779275661997.png

 I've read other posts about this issue and tried everything to no avail.

 

Hope someone can shed some light on why this is happening.

1 ACCEPTED SOLUTION
ArchStanton
Power Participant
Power Participant

So I've just managed to fix it and possibly anyone else who has gone round in circle trying all the obvious things.

I went into Query Editor and duplicated my date column, once that was loaded into my data model it was a case of right-clicking and creating a date hierarchy which it did with no problems. I deleted the old one and renamed the new one to the what the old one was called so all my measures continue to work.

View solution in original post

1 REPLY 1
ArchStanton
Power Participant
Power Participant

So I've just managed to fix it and possibly anyone else who has gone round in circle trying all the obvious things.

I went into Query Editor and duplicated my date column, once that was loaded into my data model it was a case of right-clicking and creating a date hierarchy which it did with no problems. I deleted the old one and renamed the new one to the what the old one was called so all my measures continue to work.

Helpful resources

Announcements
Fabric Data Days is here Carousel

Fabric Data Days 2026

Don't miss out on Data Days, June 15 through August 7. Learn Fabric, Power BI, SQL, AI and more.

May Power BI Update Carousel

Power BI Monthly Update - May 2026

Check out the May 2026 Power BI update to learn about new features.

Power BI DataViz World Championships carousel

Power BI DataViz World Championships - June 2026

A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.