Forum Discussion
Helper IDate field no more(?) data type after I create a relationship
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)
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.
3 Replies
- HotChilli
Community Champion
This is standard behaviour. The hierarchy switches to 'the other side'
6DiegoDiego9I 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:
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.
