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

%3CLINGO-SUB%20id%3D%22lingo-sub-1535138%22%20slang%3D%22en-US%22%3EExpand%20%2F%20collapse%20columns%20-%20in%20an%20excel%20pivot%20created%20from%20GetData%20PowerBI%20dataset%20(channel%20prev%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1535138%22%20slang%3D%22en-US%22%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EI%20have%20created%20a%20pivot%20from%20my%20power%20BI%20dataset%20(using%20Get%20data%20%2F%20powerBI%20dataset%20-%20I%20have%20a%20channel%20preview%20account%20)%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EIn%20a%20traditional%20pivot%20you%20can%20expand%20and%20collapse%20data%20in%20columns%20from%20the%20header%20regardless%20of%20whether%20you%20have%20already%20expanded%20some%20individual%20items%20int%20he%20column.%26nbsp%3B%20%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EIn%20the%20powerBi%20dataset%20based%20pivot%20%2C%20if%20you%20have%20already%20manually%20expanded%20one%20or%20two%20items%20(in%20say%20columns%203%20and%204)%20you%20have%20to%20go%20back%20and%20collapse%20everything%20from%20the%20first%20column%20and%20then%20re-expand%20whole%20columns%20to%20show%20all%20the%20data.%26nbsp%3B%20If%20you%20collapse%20the%20entire%20field%20for%20column%203%20(currently%20part%20expanded)%20and%20then%20expand%20all%20on%20column%203%20it%20will%20just%20go%20back%20to%20your%20part%20expansion%20-%20not%20to%20expand%20all.%26nbsp%3B%20Until%20you%20collapse%20all%20in%20all%20the%20previous%20columns.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3ECommunity%20support%20over%20in%20Power%20BI%20think%20it%20is%20designed%20but%20would%20be%20interested%20to%20here%20from%20the%20excel%20experts%20-%20is%20this%20expected%20behaviour%3F%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1535138%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EBI%20%26amp%3B%20Data%20Analysis%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EPower%20BI%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Frequent Visitor

 

I have created a pivot from my power BI dataset (using Get data / powerBI dataset - I have a channel preview account )

 

In a traditional pivot you can expand and collapse data in columns from the header regardless of whether you have already expanded some individual items int he column. 

 

In the powerBi dataset based pivot , if you have already manually expanded one or two items (in say columns 3 and 4) you have to go back and collapse everything from 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.

 

Community support over in Power BI think it is designed but would be interested to here from the excel experts - is this expected behaviour?

 

0 Replies