Date field looses 'Date hierarchy' when have relationship

[saxenaa]

Hey Guys,

probably obvious, I have a field 'Created' of type Date in a table, and I have other table created using Dax fuction CALENDAR the field 'MyDate' type is Date as well , now when I create a relationship between 'Created' and 'MyDate'  I loose date hierarchy capabilities on 'Created' field on visualization

However I still get to see date hierarchy  if I use 'MyDate'.

why is it like this?

[PicPay_Sam]

Wow this software is so limited.

[jess]

hi all,

i have been using data source as cosmosDb in powerbi to create report.Yeaterday i created few reports by using date hierarchy.today i was opening the report my date hierarchy was missing and drilldowns are not working.becuse obviously there is no date hierarchy to work fro drilldown can someone please help me with this.

[v-ljerr-msft · Accepted solution]

Hi @saxenaa,

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. 

Regards