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
chudson
Helper IV
Helper IV

Does Anyone Know why Date Hierarchies are not showing up in .PBIX files anymore?

Hi,

 

I am using date fields in matrixes and when I opened up a few of my desktop files today none of the date hierarchy fields are there, it is just the date per column.  Does anyone know why this is?  I don't even have the option to select the date hierarchy for these dates which makes no sense because I had this option a few days ago.

 

I haven't changed anything in my model yet and just noticed this when trying to do a few enhancements/updates.

 

 

Thanks,

 

 

1 ACCEPTED SOLUTION

I believe I figured out what went on here. 

 

I created another relationship to that date column and for some reason PBI removed the hierarchy set so to fix I just created a datekey string column in both tables and set the relationship to those columns and now the date hierarchy is back on my date column.

 

 

Thanks,

View solution in original post

4 REPLIES 4
OwenAuger
Super User
Super User

@chudson

By any chance is "Mark as Date table" selected for your Date table (Modelling => Calendars or on the table context menu)?

 

If "Mark as Date table" is selected, then the automatic date hierarchy disappears for any date columns of the Date table itself or date columns of other tables that are related to the Date table's date column.

 

If that's not the case, then that's a little puzzling...could you share a sanitised pbix file demonstrating the problem?

 

Regards,

Owen


Owen Auger
Did I answer your question? Mark my post as a solution!
Blog
Twitter
LinkedIn

Also check in File -> options and settings -> Options -> Data Load , Auto Date/Time is not unchecked.



Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤


Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

I believe I figured out what went on here. 

 

I created another relationship to that date column and for some reason PBI removed the hierarchy set so to fix I just created a datekey string column in both tables and set the relationship to those columns and now the date hierarchy is back on my date column.

 

 

Thanks,

kwinker0113
New Member

I am having the exact same issue, and my time intelligence quick measures have stopped working, need some help ASAP please.

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.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

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

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.