Date field no more(?) data type after I create a relationship

[6DiegoDiego9]

After I create a relationship between the date fields of two tables, the left one seems no more seen as a date:

Why?

After I create this relationship I'm no more able to create/see the typical date hierarchy (Years, Months, Days)

[Anonymous · Accepted solution]

Hi @6DiegoDiego9 ,

• Here is a blog talking about  Why there is no date hierarchy - Microsoft Power BI Community Please kindly refer to:

• You could follow these steps to get hierarchy back.

1. Add columns to Table2:

Year = YEAR([Date])
Quarter = QUARTER([Date])
Month = FORMAT([Date],"mmmm") 
Day = DAY([Date]) 

2. Right-click Date column -> Create Hierarchy

3. Right-Click the new added columns -->Add to Hierarchy

Below is the final output:

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

[HotChilli]

This is  standard behaviour.  The hierarchy switches to 'the other side' 

[6DiegoDiego9]

I used to put that left DATA field in Shares axis of a chart.
Now it lost the hierarchy.

How do I restore the hierarchy?  if I add it manually, I get this, that doesn't help: