Forum Discussion
Date heirarchy labels missing from visualization
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)
When adding the Calendar[Date] field to a table or chart, Power BI should automatically create a date hierarchy (Year, Quarter, Month, Day).
If you don’t see it, right-click the date field in the Fields pane and check if “Date Hierarchy” is available.
** You don’t need to create a relationship with the Date Hierarchy itself only between Calendar[Date] and Ticket data[Created date].
Try recreating the relationship by dragging Calendar[Date] to Ticket data[Created date] in Model View.
Let me know if this helps! If this response was helpful, please accept it as a solution and give kudos to support other community members.
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.