Power BI Desktop - On screen Matrix Grouping

[venstart]

Hi there

I need help with my Power BI Report, so I got a Date slicer to select my data between these dates. Then I have a matrix table with all my fields and columns and values.  Below is a screenshot of the (filtered) Matrix table

Now I want to group & sum the " Lenght" column, so what I mean. Currently there is 4(row) x 3.0 lenght in the Matrix, but I want 1 (row) x 3.0 lenght with the grouped & sum value for "13", "14", "15", 16" etc right to end

So example: if we take 3.0 grouped then column "21" should have a group sum value of 67

How can I do this.

[Anonymous · Accepted solution]

Hi @venstart 

Due to I don’t know your data model, I build a sample to have a test.

My sample data:

Your original matrix visual may like:

You want to group the values by Length, so you can change the level of length and load sheet No in Rows.

New visual:

Best Regards,

Rico Zhou

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

[venstart]

@Anonymous Thank you, its worked