Power BI Builder Matrix Grouping

Hi amsrivastavaa ,

Use the matrix wizard to provide a starting design on which to display data. The preview pane in the wizard helps you to visualize the result of grouping data before you complete the matrix design.

1. On the Arrange fields page, drag Territory from Available fields to Row groups.
2. Drag SalesDate to Row groups and place it below Territory.
3. The order in which fields are listed in Row groups defines the group hierarchy. Steps 1 and 2 organize the values of the fields first by territory, and then by sales date.
4. Drag Subcategory to Column groups.
5. Drag Product to Column groups and place it below Subcategory
6. Drag Sales to Values. 
7. Drag Quantity to Values.
8. Click Next.
9. On the Choose the Layout page, under Options, verify that Show subtotals and grand totals is selected.
10. Verify that Blocked, subtotal below is selected.
11. Verify the option Expand/collapse groups is selected.
12. Click Next.
13. Click Finish.
14. Click Run to preview the report.
15. Expand a subcategory. You can see the report quickly gets quite wide.

For more details, you can read related document: Tutorial: Creating a Matrix Report (Report Builder) - SQL Server Reporting Services (SSRS) | Microsoft Learn

Best regards,
Community Support Team_ Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi Anonymous , Thanks for the response.

I am able to create Matrix with Options : Stepped, Subtotal, however, I want to create the same (matrix with Stepped Option) but manually i.e. without using Matrix Wizard

Snapshot of what I am getting it via Wizard is shown.

Please suggest!!

Thanks

A