Forum Discussion
Date Hierachy Missing
Hello All, The Date Hierachy is not showing up in my BI reports on Desktop. I checked sttings and Time intelligence is checked. How can I add to manually to fix? ...
Hi Anonymous
This blog should be helpful: Why there is no date hierarchy - Microsoft Power BI Community
To see the auto date hierarchy, you need to ensure the following 5 conditions:
- Enable automatic date/time option
- The table storage mode is Import
- The column data type is date or date/time
- The column isn't the "many" side of a model relationship
- No table is marked as date table
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.
amitchandak
Super User
Super UserAnonymous , I think the option is there at both global and report levels. check at the report level too.
Also, when the date is joined with the date(which is key) in the date table, marked as a date table. It will not show hierarchy. You can duplicate the join column and check
What do you mean by duplicating join column?