Expand and collapse in matrix visual (Public Preview)

Note

These release notes describe functionality that may not have been released yet. To see when this functionality is planned to release, please review Summary of what’s new. Delivery timelines and projected functionality may change or may not ship (see Microsoft policy). For detailed information about our products, visit the Power BI documentation.

End users who are familiar with the PivotTable experience in Excel need a similar one in the Power BI matrix visual. Users can expand items in the matrix to see details while still showing higher-level information.

You can create a multilevel hierarchy on matrix visuals by adding multiple fields to the ‘Rows’ area of the field well. You can then expand and collapse items in the matrix hierarchy by clicking the plus/minus buttons to show details at a lower level.

Resources

Expand and collapse matrix visual