Forum Discussion

KrystianPowerBI's avatar
KrystianPowerBI
Frequent Visitor
2 years ago

Expand all visual (matrix) in PowerBi Mobile app Android/IOS

Is there option to Expand all rows by using something similar to  attached "Expand all" pbi service function and avoid click everytime plus sign?

 

3 Replies

  • KrystianPowerBI 

    Power BI service does not offer a built-in "Expand all" function like the one shown in the attached image. However, there are a couple of alternative approaches you can consider to achieve a similar result:

    1. Multi-Row Selection: You can select multiple rows in the table visual by clicking and dragging to select a range of rows. Once multiple rows are selected, you can then use the right-click menu or the toolbar at the top of the table visual to expand all selected rows at once.

    2. Drill-Down/Drill-Up: If your table visual is configured with drill-down capabilities, you can use the "Drill up" option to expand all rows to their highest level of detail. This option is available in the toolbar at the top of the table visual when drill-down is enabled.

    3. Custom Bookmark: Create a custom bookmark in your report that expands all rows in the table visual, and then use the bookmark feature to apply this expansion state to the table. Users can then use the bookmark pane or bookmarks toolbar to easily apply the "Expand all" bookmark as needed.

    4. Paginated Report: If your report contains a large number of rows and expanding all rows in the table visual is impractical, consider using a paginated report instead. Paginated reports allow for more granular control over the display of data and can handle large datasets more efficiently.

      Did I answer your question? Mark my post as a solution! Appreciate your Kudos !!

  • Hi KrystianPowerBI 

     

    Yes, unfortunately the "Expand all" feature isn’t available in the Power BI mobile app  it’s a known limitation. On mobile, you’ll have to manually expand each level in the matrix, which I agree isn’t ideal.

     

    If you’re trying to share an already-expanded view, one workaround is to set up a bookmark from the desktop with the matrix fully expanded, then direct users to that specific view. It’s not interactive but can help with presentation.