Forum Discussion
Solved
Date heirarchy labels missing from visualization
I'm building my first data model, and I've run into my first major roadblock, the date heirarchy doesn't show any labels on the table. This is true regardless of the measure I select, or if I select ...
Hello, oftenconfused ,
this will sound silly, but double check that the Created Date is set as DATE data type in Power Query (often it can be set to Datetime, or nothing/any so watch for that)
ArwaAldoud
Hi,
when you use the calendar (and you have it also marked), this auto hierarchy is disabled. You can also disable it by default in settings, which is always the preferred way. Auto date tables are only causing performance issues.
In these kind of issues, the problem is usually around data types of the keys used to create the relationship, as it was in this case.
Thanks for the clarification about the hierarchy being disabled when using a marked calendar. vojtechsima Appreciate your insight.