cancel
Showing results for 
Search instead for 
Did you mean: 
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!

My Blog
Connect on Twitter
Connect on LinkedIn

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






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
August 2022 update 768x460.jpg

Check it Out!

Click here to learn more about the August 2022 updates!

August 1 episode 9_no_dates 768x460.jpg

The Power BI Community Show

Watch the playback when Priya Sathy and Charles Webb discuss Datamarts! Kelly also shares Power BI Community updates.

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Top Solution Authors
Top Kudoed Authors