Expand / collapse columns - in an excel pivot created from GetData PowerBI dataset (channel preview)

[Anonymous]

Is this a bug or will it be forever:

In a traditional pivot you can expand and collapse data in columns from the header.  In this instance, if you have already manually expanded one or two items (in say columns 3 and 4) you have to go back and collapse everything fomr the first column and then re-expand whole columns to show all the data.  If you collapse the entire field for column 3 (currently part expanded) and then expand all on column 3 it will just go back to your part expansion - not to expand all.  Until you collapse all in all the previous columns.

[v-eachen-msft · Accepted solution]

Hi @Anonymous ,

I think it is designed. You could also post your topic in Microsoft Excel Community. The experts over there may have different opinions.