Forum Discussion
6DiegoDiego9
Helper I
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 th...
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
Community Champion
Community ChampionThis is standard behaviour. The hierarchy switches to 'the other side'
6DiegoDiego9Helper I
Helper II 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: