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
Anonymous's avatar
Anonymous
Not applicable
8 years ago

Can you tell me how you can expand just one node please?

 

Thanks a lot!

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.