Forum Discussion
Expand / collapse columns - in an excel pivot created from GetData PowerBI dataset (channel preview)
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.
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.
1 Reply
- v-eachen-msft
Community Support
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.