Custom Data Table Not Working

[kobe]

In order to add Week to date hierarchy, I create a table and add four columns. Then I create the hierarchy and add them to it. 

I mark the table as a date table and add a relationship with the "export" table.

This table isn't still working like the auto date hierarchy in the "export" table. Anything is missing? 

[kobe]

It's working when I create the custom date hierarchy in the "export" table. 

[Idrissshatila]

Hello @kobe ,

can you make sure that both date columns have the same data type, like both date .

and make sure the the export table has the same data type in power query.

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin
Vote For my Idea💡

[kobe]

I confirm both columns have the same Data type which is Date/time with the same format. When I create the custom data hierarchy in Date Table, the auto-generated one in the export table disappears. 

I create a custom one within export table and it's working but the order of date legend is sorted.

[Idrissshatila · Accepted solution]

Hello @kobe ,

can you try cinverting both columns into date type.

the date in export table is should be converted to date type in power query.

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin
Vote For my Idea💡

the 

[kobe]

Just to double confirm that you mean converting data type of both conlumns from "Date/time" to "Date"? Anyway I will try it tomorrow.

[Idrissshatila]

@kobe , Yes.

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin
Vote For my Idea💡