Forum Discussion
Solved
Pivot table manual row label filter no longer allows expand/collapse hierarchy
I have two fields under row labels. Up until a couple of weeks ago, I was able to filter on both these fields using the manual row label filter. Now, for some reason, I am unable to do so. Pr...
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.
abwconsulting , you are welcome