How to remove a column from Date Hierarchy?

[BenBlackswan]

Hello everyone,

After a column has been placed into a Date Hierarchy, how can it be removed from that hierarchy? For example, currently I have the Year and the Quarter column in the Date Hierarchy, but when I right click on the Quarter column, there is no option for me to remove it nor can I drag it out of the Date Hierarchy.

Any help would be greatly appreciated.

[Idrissshatila]

Hello @BenBlackswan ,

you go in the data model view, then click on the hierarchy , then you will see as in the screenshot you could click X to remove it then the apply changes button will be available to click so ou click it and it will be removed.

[calerof]

Hi @BenBlackswan,

Use "Delete from model". It'll delete the object in the hierarchy, not the column from the table.

Cheers,

Fernando