Forum Discussion

Anonymous

Not applicable

6 years ago

Solved

Losing date hierarchy

I have created a date dimension connected to a table. I need to connect the date dimension to another table but when I do this, the second table date field loses its hierarchy. Any ideas?

General Comment

Need Help

amitchandak
6 years ago
Anonymous

These are the reasons Date Hierarchy can be missing
https://community.powerbi.com/t5/Desktop/Date-Hierarchy-Doesn-t-show/td-p/525460
https://community.powerbi.com/t5/Desktop/Date-hierarchy-not-available/td-p/438804
https://community.powerbi.com/t5/Desktop/Lost-Missing-Date-Hierarchy/td-p/421045

Check Settings
https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-auto-date-time

create a new hierarchy
https://www.tutorialgateway.org/create-hierarchy-in-power-bi/
https://www.youtube.com/watch?v=x6vXVJZ_eTY

For date table, Date will become key and will not have hierarchy

amitchandak

Super User

6 years ago

Anonymous

These are the reasons Date Hierarchy can be missing
https://community.powerbi.com/t5/Desktop/Date-Hierarchy-Doesn-t-show/td-p/525460
https://community.powerbi.com/t5/Desktop/Date-hierarchy-not-available/td-p/438804
https://community.powerbi.com/t5/Desktop/Lost-Missing-Date-Hierarchy/td-p/421045

Check Settings
https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-auto-date-time

create a new hierarchy
https://www.tutorialgateway.org/create-hierarchy-in-power-bi/
https://www.youtube.com/watch?v=x6vXVJZ_eTY

For date table, Date will become key and will not have hierarchy

Forum Discussion

Losing date hierarchy

Related content

Date hierarchy

Date Hierarchy

Date Hierarchy does not get generated

Datasets keep losing gateways

Hierarchy Slicer Metadata for Auto Date/Time Hierarchies in Power BI Embedded