March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now
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.
Hello @Nietzsche ,
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.
Proud to be a Super User! | |
Hi @Nietzsche,
Use "Delete from model". It'll delete the object in the hierarchy, not the column from the table.
Cheers,
Fernando
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
User | Count |
---|---|
93 | |
92 | |
86 | |
77 | |
49 |
User | Count |
---|---|
166 | |
149 | |
99 | |
73 | |
57 |