date hierarchy missing

[Anonymous]

hi all,

why the date hierarchy does show in the axis.

my date column is already formatted to date.

i have a calendar table & relationship is linked to it. Any advice?

[amitchandak]

Is it marked as date table? Right click on table Name. There is an option

Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blog -
https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...
https://community.powerbi.com/t5/Community-Blog/Power-BI-Working-with-Non-Standard-Time-Periods/ba-p...
https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601

[Anonymous]

@amitchandak @SivaMani I got error "date column can't have gaps in dates"

any idea how to solve that?

[amitchandak · Accepted solution]

@Anonymous 

Make sure you create Date table using calendar command

https://radacad.com/creating-calendar-table-in-power-bi-using-dax-functions

[v-lionel-msft]

Hi @Anonymous ,

It's impossible to sue "date hierarchy" if you use "Direct Query" connection model.

And  as tested, the date hierarchy cannot be displayed if this column is linked to other column.

The impact of table relationships on date hierarchies

1:1

1:*

(1: the date can use hierarchy; *: can't)

*:*

Smmarize: only one side of the date can use the date hierarchy. 

So you may need to modify your table model.

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[SivaMani]

@Anonymous,

Please check the below cases,

• No hierarchy will be created 
  • when the date table on the Many side relationship
  • In Direct Query connections
• Try to mark your table as a Date table
  • Right-click the table and select Mark as date table > Mark as date table in the menu - https://docs.microsoft.com/en-us/power-bi/desktop-date-tables#setting-your-own-date-table

Hope it will help you!