Forum Discussion
Measures in Matrix visual on Rows - how to group them?
I have got measures that I show in a matrix visual on rows. Is there a way how they could be group or even collapsed together?
I imagine I can do a new measure for each subtotal of measures which I want, but it is not very elegant.
4 Replies
Can you elaborate your requirement? What do you mean by grouping of rows.
If you are looking to create custom or hybrid matrix, refer https://community.powerbi.com/t5/Community-Blog/Creating-a-custom-or-hybrid-matrix-in-PowerBI/ba-p/1354591
See attached the matrix visual with measures on rows:
matrix visual with measures shown on rows
The question is, how to group or how to create a hierarchy for measures?
Can you give the screenshot of the visualisation pane and alsoprovide the raw data and based on what category do you want to group the rows?
As far as I understand what's displayed, this should be rather done using the "category" dimension instead of having a standalone measure for each of the rows.
