date hierarchy

[waleed111]

when i make one to many relationship between tow date column on of the them loss its hierarchy:

it come like this without hierarchy:

so how can i return its hierarchy and make it like this column:

 

 

[amitchandak]

@waleed111 ,

refer These are the reasons Date Hierarchy can be missing
https://community.powerbi.com/t5/Desktop/Date-Hierarchy-Doesn-t-show/td-p/525460
https://community.powerbi.com/t5/Desktop/Date-hierarchy-not-available/td-p/438804
https://community.powerbi.com/t5/Desktop/Lost-Missing-Date-Hierarchy/td-p/421045

Check Settings
https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-auto-date-time

And if need create a custom hierarchy

https://www.tutorialgateway.org/create-hierarchy-in-power-bi/
https://www.youtube.com/watch?v=x6vXVJZ_eTY

[waleed111]

i found this solution in the first link that you share: (Did you establish relationship with an other table based on [Contact date]? If so, it won't show hierarchy when adding [Contact date] to visuals.)

so if i want to keep the relationship, do i have to make my costum hierarchy? 

[v-diye-msft · Accepted solution]

Hi @waleed111 

It seems to be the default behavior, and I don't think there is an option to change it currently. 

An alternative solution is to create a new calculated column "Created2= 'theTable'[Created]" in your table and then use Created2 column instead to get hierarchy back.

[amitchandak]

@waleed111 , Try this if the Contact date is joined with date in the date table. Delete relations and check if you get back the date hierarchy and try to create relations again. This was one suggestion at someplace. I never tried. as I typically use a date table. 

You can see if you can create a custom hierarchy.

[VijayP]

@waleed111 

Goto Options and Setting in File Tab to get Optiosn Dialogue and then check the box in the highlighted area (Time intelligence)

[waleed111]

it checked but nothing happen.

[VijayP]

@waleed111 

Save the File and Restart Power BI to see the effect