Forum Discussion
Create Date Hierachy
hi all,
i have a simple date column EI. I want to create a Date Hierarchy like
With Date Hierachy / Year / Quarter / Month / Day and want to use this column in a measure.
Should be simple or? But coundnt find a way to do this.
Nothing works. At the date column i dont see this white date kalender picture which i want to expand. when i create hierchy no year/month/quarter/day is automatically added and i cant use it in measures.
The hierachy is always a new column that i dont want.
Solved was a mistake. cant take it back.
6 Replies
Pikachu-Power , you can create a new hierarchy
https://www.tutorialgateway.org/create-hierarchy-in-power-bi/
https://www.youtube.com/watch?v=x6vXVJZ_eTY
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/421045Hi,
Normally date hierarchy are automatically made by Power BI, except if your set it differently in the option of the software.
If your table is marked as a Date Table, then you will not have hierarchy.
Anyway the best option for you might be to create a Date Table and linked it to your fact table. The you'll have all the hierarchy you need.
Another option is to create your columns using YEAR(), MONTH() functions.
But still my recommendation would be to create a date table. If you want to know more about it, many discussions have been made :
Hope this help
Make sure that you DateColumn has Date format so automatically it will create hierarchy. Else Create three different Column for Year, Month, and Date then add into hierarchy.
Nothing works. At the date column i dont see this white date kalender picture which i want to expand. when i create hierchy no year/month/quarter/day is automatically added and i cant use it in measures.
The hierachy is always a new column that i dont want.
Solved was a mistake. cant take it back.
Hierachies i cant use in measures right? How do i create this white date table which i can expand to the hierachie?
