Forum Discussion

Prakest's avatar
Prakest
Frequent Visitor
2 years ago
Solved

Collapse and expand columns on matrix

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

Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    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.

2 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Icon for Community Champion rankCommunity Champion
    2 years ago

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    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.