Forum Discussion

OneWithQuestion's avatar
OneWithQuestion
Icon for Post Prodigy rankPost Prodigy
9 years ago

Expand/Collapse Hierarchies in Tables/Matrix?

In Excel, SSRS, etc... you can easily use a hierarchy and it will make the table/matrix expandable with little + and - buttons:   Is there still no way to accomplish this with Power BI?   F...
Need Help
tjd's avatar
tjd
Icon for Impactful Individual rankImpactful Individual
8 years ago

Clicking on the drilldown arrow on the far right activates "cell" drilldown.  With the arrow activated (dark), you can then click on a row cell header and it will drill down on just that cell to the next level.  Click a cell again and it will go to the next level for just that cell.  Pretty slick!  Hope this helps.

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hi tjd

 

I see what you mean. This can fix the problem already a little bit. Thanks! 

 

Indeed not that user friendly and all the other "high levels" are not visible anymore, but OK for now :)

 

Thanks a lot!!