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.
Forgive me but where do I check report levell settings? Ex. Go to desk top =>File => options settings =>options => ?
Samarth_18Community Champion
Anonymous Yes under current file you check for below option:-
Its checked in the Data Load already.