Forum Discussion
APM
Helper I
5 years agoDate Hierarchy gone after marking as date table
Hi, I recently created a custom calendar in PowerBi as a new table. It auto-generated a date hierarchy: However, once I went into the 'Date' table I created and hit "Mark as Date T...
- 5 years ago
Hi APM ,
You need to first create 4 columns:Year,Quarter,Month,Day:
Then right click on ...of year column:
choose "New hierarchy";
Then rename it as "Date hierarchy";
Right click ...of other 3 columns>"Add to hierarchy":
And you will see the complete date hierarchy as you wish.
Check the reference below:
https://spreadsheeto.com/power-bi-hierarchy/
Best Regards,
KellyDid I answer your question? Mark my post as a solution!
amitchandak
Super User
5 years agoAPM , If you mark Table as Date table, Date will become Key and you will not be able to use date hierarchy. It is expected behavior