Forum Discussion
Pivot table manual row label filter no longer allows expand/collapse hierarchy
If in your data model Field1 and Field2 are in hierarchy and hierarchy is added to rows in PivotTable, it shall work as "before" in your case
If to add to PivotTavle fields themselves, not hierarchy, behavior will be as what you have "now"
If in your data model Field1 and Field2 are in hierarchy and hierarchy is added to rows in PivotTable, it shall work as "before" in your case
If to add to PivotTavle fields themselves, not hierarchy, behavior will be as what you have "now"
Thanks so much, Sergei!
Just to clarify, the creation of the hierarchy takes place in the Power Pivot window, not in the Power Query Editor, yes? At least this is where I was able to do it, following your instructions.
I could swear that when I first created the pivot I did not create a hierarchy, but the pivot displayed a hierarchical filter nevertheless. It does seem as though something has changed in Excel since that time. (Indeed, I received at least one Office 365 update since that time.) Regardless, this now works, and you have my sincere thanks.
Best regards,
Tom
Tom, yes, that's Power Pivot, hierarchy exists in data model. Date/Time hierarchy is added automatically if only you didn't disable this setting, other ones you may create manually.
Thanks, Sergei.
