Feature Similar to Excel's Column Grouping?

[kurtsmetana]

Hello, I am trying to emulate some functionality in an existing Excel file, but can't seem to find the right solution.

Excel allows you to group columns, along with the ability to expand / collapse.  This helps reduce the amount of numbers a user has to look at by default, but if they want more detail they can expand the columns.

I know in a matrix visual this is built into the row functionality, but I don't see a way to expand / collapse columns.  Any ideas??  Thanks

[amitchandak · Accepted solution]

@kurtsmetana , If you more than one column in col of the matrix, then there is an option to drill down at the column level.

But with one col and multiple fields/values it is not.

Refer:https://docs.microsoft.com/en-us/power-bi/visuals/desktop-matrix-visual

[az38]

Hi @kurtsmetana 

I do not see such option in in-build Power BI visuals, maybe you can find something in AppSource https://appsource.microsoft.com/en-us/marketplace/apps?product=power-bi-visuals