How do you reapply a date hierarchy in Power Bi

[Jay2022]

How do I reapply a date hierarchy in Power Bi when i've removed the hierarchy previously?

[v-xinruzhu-msft · Accepted solution]

Hi @Jay2022 

The solution @Sahir_Maharaj  offered is right, recreate a hierarchy, but you need to create four new clumns in table first.

e.g Year=Year(Table[Date])

Quarter=Quarter(Table[Date])

Month=Month(Table[Date])

Day=Day(Table[Date])

Then select create the hierarchy, put the fields above to it.

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Kai_PBI]

Fantastic this worked! Also... I had Time Intelligence de-selected within my file (in Options) so it didnt register a hierarchy to start with.

[Jay2022]

Hi Sahir, 

Thank you for your help. There doesn't appear to be a create hierarchy option on the new version of power bi only a 'create hierachy' option i tried this but it doesn't seem to work.

Thanks 

[Sahir_Maharaj]

Hello @Jay2022,

Can you please try these steps to re-apply a date hierarchy:

1. Go to "Data" view and find the table with the date column.
2. Right-click on the date column. Navigate to "Hierarchy" > "New Hierarchy."
3. Drag and drop date columns as levels in "Edit Hierarchy" dialog and name the hierarchy.

Should you require further details or information, please do not hesitate to reach out to me.