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
igorabdo's avatar
igorabdo
Icon for Advocate II rankAdvocate II
8 years ago

Today isn't possible.

It will be in October release

tjd's avatar
tjd
Icon for Impactful Individual rankImpactful Individual
8 years ago

Perhaps I'm missing something, but you can do this in the current matrix visual using drilldown.  And, it's more powerful as you can drill down/up by levels, nodes, or, levels and nodes - by rows or by columns.  It's just not as intuitive as having the "+" and "-" buttons next to each row.

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Hi tjd,

     

    Can you show us how? Just one node, not all of them? I can drill down one level, but than all of the nodes will expand...

     

    Thanks a lot!

    • 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!!