Forum Discussion
Power BI Desktop - On screen Matrix Grouping
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.
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.
2 Replies
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.
Anonymous Thank you, its worked
