Skip to main content

Power BI

Needs Votes

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

Vote (4814) 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 (75)
Miguel Myers's profile image Profile Picture

Power BI User on 05 Jul 2020 23:36:34

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

Being able to expand and collapse columns is a critical feature for finance and operational reporting where hierarchies are used (e.g. time - months, quarter, years).

Miguel Myers's profile image Profile Picture

Alfonso Perez on 05 Jul 2020 23:36:26

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

Hi. First of all the expand/collapse on Rows is GREAT!.

I would like it also on Columns.
Right now I am doing a Sales Dashboard and I need to add a + sign to expand to show UNITS as well as the Sales Amount. So I definitely think it would be a great add.

Miguel Myers's profile image Profile Picture

Chi Truong on 05 Jul 2020 23:36:18

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

Yes please!

Miguel Myers's profile image Profile Picture

Power BI User on 05 Jul 2020 23:36:17

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

now that this feature was released i'm kind of disappointed because DOES NOT WORK for multidimensional cubes!!!!

Are you have an estimated date when it is going to be available for multidimensional cubes (MD)?

Miguel Myers's profile image Profile Picture

Vishnu M on 05 Jul 2020 23:36:16

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

Yes, it would be helpful.

Miguel Myers's profile image Profile Picture

Girish K Ranganath on 05 Jul 2020 23:36:09

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

This is very helpful

Miguel Myers's profile image Profile Picture

Silas Fisher on 05 Jul 2020 23:36:03

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

This would be very helpful! We have an immediate need.

Miguel Myers's profile image Profile Picture

Preethi on 05 Jul 2020 23:35:48

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

Yes we need this Visual

Miguel Myers's profile image Profile Picture

Power BI User on 05 Jul 2020 23:35:34

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

Yes, needed for showing Year -> Quarter -> Month.

Miguel Myers's profile image Profile Picture

Andreas S. on 05 Jul 2020 23:35:27

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

Time examples have already been posted and valid for me as well. Beside that I'd like to generally be able to show aggregated information in columns which are shown per default, but add additional information for the user in per default hidden columns beside, which the user can expand if he's interested in (to give one other example: to e.g. see which orders on hand are already confirmed, overdue, etc.)

Merged Idea (1)