Collapse and expand columns on matrix

[Prakest]

I have a dataset from which business would like to see 4 primary/composite metrics as well the ability to see the submetrics. Based on the idea below this does not seem feasible (i.e. doing it on the same page) but what are some other options to replicate this functionality?

https://ideas.fabric.microsoft.com/ideas/idea/?ideaid=151a8279-d892-4e52-8cec-4f3b69bdbc6c

[Anonymous · Accepted solution]

Hi, @Prakest 

Thanks for the reply from Prakest , please allow me to provide addition:

You can expand/collapsible rows and columns, implement expandable and collapsible rows and columns in a matrix. This can be done in Power BI by enabling the plus/minus icon in the field format pane. The user can then expand or collapse the section as needed.

Or create a hierarchical view, which creates a hierarchical view where the main metrics are at the top level and the sub-metrics are nested below. This can be done using a pivot table in Excel or a matrix visual in Power BI. You can check the following link:

How to Expand All Rows in a Power BI Matrix by Default (hatchjs.com)

How to Get Your Question Answered Quickly 

Best Regards

Yongkang Hua

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Greg_Deckler]

@Prakest You could possibly do this using drilldown functionality. Might need a disconnected table to pull it off.