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.
2 Replies
- amitchandak
Super User
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/421045Custom Hierarchy
https://stoneridgesoftware.com/creating-hierarchies-in-power-bi/
https://www.youtube.com/watch?v=x6vXVJZ_eTY Hi Anonymous ,
Firstly, you don’t have to create hierarchy. You can achieve identical functionality by adding multiple columns(Year, Month) to the "Axis" of a bar or column chart. This way, the chart will also enable you to dill down the data.
Secondly, you are able to create Date table using M query or DAX expressions in Power BI Desktop. For more detailed steps, please review the following blogs.
http://www.agilebi.com.au/power-bi-date-dimension/
http://kohera.be/blog/business-intelligence/how-to-create-a-date-table-in-power-bi-in-2-simple-steps...Best Regards
Community Support Team _ polly
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
