Skip to main content

Power BI

Needs Votes

Epic idea: Hide, show, expand, and collapse tabular columns

Vote (4921) Share
Miguel Myers's profile image

Miguel Myers on 08 Oct 2024 05:00:00

It would be beneficial to incorporate features from Pivot tables that allow for the expansion and collapse of columns and hierarchical column groups within tabular visuals. This would not only solve the current limitations of matrices but also provide report creators with the flexibility to hide and show rows and columns, saving these settings for future use, thus eliminating the need to scroll through irrelevant data.

Comments (77)
Miguel Myers's profile image Profile Picture

Power BI User on 05 Jul 2020 23:46:01

RE: Epic idea: Hide, show, expand, and collapse tabular columns

Replicating Excel reporting and found that column group expand collapse (+/-) is not available in Power Bi. Definitely needed

Miguel Myers's profile image Profile Picture

Joost on 05 Jul 2020 23:43:40

RE: Epic idea: Hide, show, expand, and collapse tabular columns

This would be a great addon!

Miguel Myers's profile image Profile Picture

Joel Faltermeier on 05 Jul 2020 23:43:15

RE: Epic idea: Hide, show, expand, and collapse tabular columns

This feature would enable many "Excel based" dashboards to be effectively created and managed in PowerBI that use wide tables with expand/collapse groupings. One more "gap closed" in PowerBI vs. Excel functionality.

Miguel Myers's profile image Profile Picture

Power BI User on 05 Jul 2020 23:41:20

RE: Epic idea: Hide, show, expand, and collapse tabular columns

This is definitely required. It will improve the UX significantly in the matrix table.

Also, is there any update on +/- button on Analysis service data source?

Miguel Myers's profile image Profile Picture

ADITHYA NAINI on 05 Jul 2020 23:40:07

RE: Epic idea: Hide, show, expand, and collapse tabular columns

This is definitely needed

Miguel Myers's profile image Profile Picture

Power BI User on 05 Jul 2020 23:40:00

RE: Epic idea: Hide, show, expand, and collapse tabular columns

This is definitely needed

Miguel Myers's profile image Profile Picture

Syd on 05 Jul 2020 23:39:39

RE: Epic idea: Hide, show, expand, and collapse tabular columns

Definitely need this. It'd be great to be able to expand the columns so we could show multiple hierarchies. The current drilldown for columns isn't nearly as user friendly as row drilldown.

Miguel Myers's profile image Profile Picture

Power BI User on 05 Jul 2020 23:39:30

RE: Epic idea: Hide, show, expand, and collapse tabular columns

Yes, please add. It will help with wide matrices.

Miguel Myers's profile image Profile Picture

Erwin van Ek on 05 Jul 2020 23:39:29

RE: Epic idea: Hide, show, expand, and collapse tabular columns

Please add this feature for us!

Miguel Myers's profile image Profile Picture

Power BI User on 05 Jul 2020 23:38:52

RE: Epic idea: Hide, show, expand, and collapse tabular columns

'+1
Please add this

Merged Idea (1)