Forum Discussion
Date hierarchy
Hello, I have a question about the date format of my table. I don't know why I can't get a Date hierarchy. I would like to get a Date hierarchy or only extract date with year 2021.
Anonymous , date from date table and date joined to it, do not provide an option for the date hierarchy. You can create a custom hierarchy in such a case. Or duplicate column to get that
date1 = [Date ]
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