Forum Discussion

APM's avatar
APM
Icon for Helper I rankHelper I
5 years ago
Solved

Date 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...
  • v-kelly-msft's avatar
    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,
    Kelly

    Did I answer your question? Mark my post as a solution!