Forum Discussion

Frequent Visitor

3 years ago

Solved

Date hierachy not working

Hi, I have a column from a Sharepoint list that is 'Date of Enquiry'. In one report it shows as a hierarchy but in another it does not. The one where it does not has a Calendar Table with a '...

Need Help

amitchandak
3 years ago
Slumpig , If You create a calendar table and marked it as date table. The key date column will lose hierarchy. And the date column joined to that date will also lose that. You can create a custom hierarchy

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

Custom Hierarchy
https://stoneridgesoftware.com/creating-hierarchies-in-power-bi/
https://www.youtube.com/watch?v=x6vXVJZ_eTY

amitchandak

Super User

3 years ago

Slumpig , If You create a calendar table and marked it as date table. The key date column will lose hierarchy. And the date column joined to that date will also lose that. You can create a custom hierarchy

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

Custom Hierarchy
https://stoneridgesoftware.com/creating-hierarchies-in-power-bi/
https://www.youtube.com/watch?v=x6vXVJZ_eTY